I have a large spreadsheet (“totals”) that references many other sheets in calculations. Example cell:
Maintaining this is a pain; every time I add a new sheet, I have to update every cell in “totals” to reference it.
Is it possible to use the value of other cells as reference IDs in a calculation? If I could put all of the sheet names in a cell or group of cells and reference them in my SUM, that would be ideal. Even better if I could also reference the row/column ID from another cell. Such as:
=SUM($A1.B1) where A1=“sheet1,sheet2,sheet3, …” and B1=“M77”.
or =SUM($A1:$A5.M77) where A1-A5 are “sheet1”, “sheet2”, etc.
Any advice would be most appreciated.