Adding cells from a growing workbook =sum('*'!C3)+C3

[wagmanm]

I have a work book that is set up to add a new tab and information around 70 times in day, 5 days a week. I want to be able to have show a cumulative total as it adds tabs of the numbers in every pages C3. I set up this formula and it works well at the end of a day if typed in. But when I put this in my template it does not look at every tab that is entered. Does anyone have any suggestions for me

 

[Jonmo1]

I suggest creating 2 dummy sheets that will hold NO information.
Call them "FirstSheet" and "LastSheet"
Place them at the far ends of the book, FirstSheet furthest LEFT, LastSheet Furthest Right.

Then use
=SUM('Firstsheet:LastSheet'!C3)

Then anytime you add a sheet, make sure it goes somewhere BETWEEN those 2 dummy sheets.

 

[wagmanm]

This sounds like a good option and I will try it. However this is a program that runs though XLRScheduler and Im not really clear on how it works, I think if I add these tabs it will just add tab 1 after lastsheet and then tab 2 and so on. I dont think I will be able to keep it at the end without changing the scheduler code. This was set up by a private company for use in our manufacturing process. I was hoping i could add a simple formula to total these amounts without involving them and getting charged for it. Are there any other ideas out there?