Easy way to roll up multiple sheets (same format) within a workbook into a separate tab?

[RSidhu]

Hi I am building a model that has same templates repeated for multiple deals. in other words, all cells across these tabs are lined up at the same place. See attached sample file.

I need a simple formula to roll up these formulas in the roll-up tab, instead of clicking on each tab 20 times.

Would it be the indirect function- i really dont know how that would work. ANything better than that? I read about 3d reference too. Let me know

I appreciate your help.

 

[vletm]

All sheets 5 rows up or down with one click from 'Roll-Up'-sheet.
Something like that?

 

[vletm]

... or with Scroll Bar on every sheet?

 

[srinidhi]

=SUM('1:5'!B3), this is called the 3D Sum, You just need to type the first sheet name & then select the cell in the last sheet, this will return the sum of all the number in inbetween tab.

 

[RSidhu]

vletm and srinidhi, no this is not what i want. on the roll up tab, i need to add the same cells on all other sheets. for example. A1 on roll up tab is the sum of a1 on sheet 1, a1 on sheet 2, a1 on sheet 3 and so son and so forth until . I will have many formuals in the roll up tab that will add up all the sub-tabs or other tabs. how do i do it other than typing the formula and selecting the same cell over and over on multiple tabs

 

[vletm]

I'll try again.
I made only a small area of 'Your sums'.
There are on every tab marked area which will notice.
The 1st tab is the 'sum-tab' and other tabs are 'sub-tabs'.
Change values of marked are of 'sub-tabs'.
Press the button and You'll get sums of every cell to the 'Sum-tab'.