Another way to do this:

Create a new empty sheet named Start and make it the very first tab in the
file.
Create a new empty sheet named End and make it the very last tab in the
file.

Then:

=MAX(Start:End!I12)

Any new sheets you create and then hide need to be placed in between the
Start sheet and the End sheet.

If you don't want to do it this way then you need some VBA code. I can't
help with that.

Biff

"Corey" wrote in message
...
Ok, got it.

I have the tabs hiden, and need it like this, so unless i manually look
for the last created sheet, i do dnot know the last value to put in the
formula?
COrey....

...
When i place that in the formula box and hit enter, it opens up a file
dialog box?

Is that right ?