Update formula to include new worksheets

[KidZest]

Hello maestros if the excel world.

Without using vba, how would one write a formula that would include all worksheets and adjust dynamically if a new sheet is added or one is removed?

Do you just create a hidden sheet and just do something like =Sum(Sheet1!A1:HiddenSheet!A1)

(currently sat trying to figure it out without the spreadsheet) also apologies if this has already been asked and answered I couldn’t find anything when I looked.

Thanking you in advance

[TMS]

It would look something like this:

Please Login or Register  to view this content.

This would sum the values in cell A1 from the start sheet to the end sheet inclusive.

I guess you could hide the start and end sheets but adding new sheets might be confusing.