I want to be able to total up monetary values in certain cells across multiple spreadsheets. The sheet tabs have been renamed and are no longer sheet 1, sheet 2, sheet 3…
How have you tried to sum them?
Did you try =[ClickCell1]+[ClickCell2+...?
The sheet tabs have been renamed and are no longer sheet 1, sheet 2, sheet 3…
… then references should be updated automatically, if you had it right before renaming the sheets.
Want to sum a cell through several sheets? Refer to the range of sheets e.g.
=SUM(Sheet1.A1:Sheet3.A1).
Source: LibreOffice Tip-of-the-day
Replace Sheet1 for the first sheet name, and Sheet3 for the last sheet name, no matter the name of the intermediate sheets.
Add Answer is reserved for solutions.
Check the mark (
→ 
) to the left of the answer that solves your question.