How to get the sum from a specific cell in every worksheet INCLUDING worksheets that do not exist yet

[jaykim215]

Hello!

This is my first time posting on these forums so bear with me please.

I had a question about possibly getting the sum of one specific cell from every worksheet INCLUDING the ones that do not exist yet.

***NOTES***
1. Every worksheet in the spreadsheet have the same template.
2. I want the sum of all I26 cells in every worksheet
3. I used the formula =SUM('*'!I26), which works fine; HOWEVER, it does not update when I add in another worksheet to the spreadsheet.
4. The worksheet names do not have a specific pattern (i.e. one worksheet is named "AAA" while another is named "El Mercado.")

I read somewhere that I can use the INDIRECT function using arrays, but the problem is that I haven't found one solution where the worksheets names are all different.

Is this possible?

Thank you,

Jay

 

[FDibbins]

if you add a blank worksheet at the start and end of your data sheets, and call them Start and End, then when you enter your calcs, you could just enter =sum('start:End'!C12) or whatever your references are. this way, you can add or remove sheets as needed, and it will add across all the sheets you need it to, and keep the totals as the data sheets change. make sure your "Master" sheet is before the Start sheet though

 

[jaykim215]

Thank you so much Ford. That was such an easy fix, I am embarrassed.

Another dumb question: Is there a way to lock the worksheets order by any chance so my Master worksheet and 'Start' Worksheet are the first two pages?