Insert a new blank worksheet at beginning...........name it Start

Insert a new blank worksheet at end.............name it End

You can hide if you wish.

Your 3-D formulas will be something like

=SUM(Start:End!A12)

When adding sheets insert them between Start and End


Gord Dibben MS Excel MVP


On Mon, 25 Jun 2007 11:03:01 -0700, tpmax
wrote:

I'm like to create a function to sum data from worksheets that have yet to be
created. I'm attempting to automate the import of new data into new
worksheets. I have considered creating hidden worksheets and ensuring that
the new worksheets are always between the hidden worksheets. I could then set
the range for the function to be the same range on the hidden worksheets and
everything between? Is there a better/simpler way to accomplish this? Thanks!