Add a new blank sheet to the right of your Summary(dedicated) sheet

Add a new blank sheet at end.

Name these Start and End.

On your Summary sheet in a cell enter =SUM(Start:End!G5)

This will sum all G5's on sheets between your two dummy sheets

In future when adding new sheets insert them between Start and End.


Gord Dibben MS Excel MVP
On Thu, 24 Jan 2008 13:24:04 -0800, LiveUser
wrote:

I am trying to make a spreadsheet that no matter what worksheet is created
anything in a cell will update a dedicated worksheet.
For Instance:

worksheet 1

G
5 67

worksheet 2

G
5 12


worksheet 3

G
5 14


The result would be:

worksheet 1


G
5 93 (total of all worksheets cell G5)

It would be best if I could have 9 worksheets that each are specifically
dedicated to a specific worksheet and cell.