Calling the last sheet added onto a master sheet

[phester90]

So I currently have a master sheet that compiles data from multiple sheets.
Each sheet is the same and corresponds to an individual sheep. Every few days a new sheep is added to the program, and thus adding a new sheet.

The problem I am having is that I have to change the last sheet being looked at on the masters page. I have over 45 formulas on the masters page so it usually takes awhile.

Here is an example of what I am using in Cell B4

=SUM('No Number:3179959'!I14)

Is there a way to have excel call the last sheet every time?

Maybe something like =SUM('No Number:END Sheet'!I14).

I appreciate all the help.

V/R

Phester90

 

[AlphaFrog]

You could use the Find\Replace dialog (Ctrl+H) to update all your formulas with the new sheet name.

Alternatively, if you copy the last sheet, then change the name of the original sheet (not the copy), the formulas will also automatically update when you change the name.