how to pull data from a specific cell on each tab as I add tabs

[egljet1]

I routinely pull data from an increasing number of tabs in a worksheet. Is
there a way to pull the data from tabs as I add them without having to change
the formula for each added tab?

 

[Shane Devenshire]

Hi,

If you are using a formula of the form:

=SUM(Sheet1:Sheet4!A1)

which sums cell A1 in all the sheets physically between Sheet1 and Sheet4
then when you want to add a new sheet and have the formula pick it up, insert
the sheet between the beginning and end sheets.

If you can't do that then insert a blank sheet at the end so that in my
formula Sheet4 is blank, then insert the new sheet before sheet4.

If this helps, please click the Yes button

Cheers,
Shane Devenshire

 

[Ron de Bruin]

Maybe this a option for you ?

You can recreate the sheet each time
Try this macro
http://www.rondebruin.nl/summary.htm