I have multiple workbooks containing a different number of worksheets with budgets in the exact same format. I would like to add a sheet (in the same format as all the sheets) in each book that sums up the other sheets in that book. In the sum-up sheet, however, I would like two cells to hold the names of the first and last sheet respectively, so that it is easy to copy the sum-up template into the other books as it is only those two cells that have to be changed. I have managed to make it work for a single cell using the following formula:<o
></o>
<o> </o>
=Sum(INDIRECT("'"&$B$4&":"&$B$5&""'!"&"D35")<o></o>
<o> </o>
Where B4 and B5 is the name of the first and last sheet and D35 is the cell that I would like the sums of (it is also the cell that the formula is in). With this formula it is not possible to add the D35 as a relative reference, so I have to manually type it in for every cell. Can I make it relative?<o></o>
<o> </o>
Thank you in advance!
></o><o
> </o>=Sum(INDIRECT("'"&$B$4&":"&$B$5&""'!"&"D35")<o
></o><o
> </o>Where B4 and B5 is the name of the first and last sheet and D35 is the cell that I would like the sums of (it is also the cell that the formula is in). With this formula it is not possible to add the D35 as a relative reference, so I have to manually type it in for every cell. Can I make it relative?<o
></o><o
> </o>Thank you in advance!
