Creating formulas to pull from specific cell in all worksheets - EXCEL2010

[larsonnj]

I am creating a summary sheet for all the worksheets in a workbook. For example, I want to be able to sum E3 from all worksheets. I have been using something like: =Sum('*'!E3). This works fine, but each week I am adding a new worksheet to the workbook and the formula does not update with the new worksheet. Is there a way to create a formula which will always Sum all E3 cells on all subsequent worksheets if I add new ones?

Thank you.

 

[RonB1111]

Create 2 new sheets called First and Last. Put all other worksheets between these 2. Then use the formula:
=SUM(First:Last!E3)

When you add new sheets each week, just make sure the sheets are placed between First and Last and the formula will automatically update.