If in specific cell in any worksheet but worksheet one add to spec

[LiveUser]

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.

 

[reitanospa1]

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.

I think you are asking about having a formula access a value on a
different sheet. If that is the case, then all you have to do is
include the sheet name with an exclamation point in the formula
(sheets with spaces in their name will require single quotes around
the name).
The easiest way to build this kind of formula is using the "operation
click" method:
1) type your equals sign where the result will be
2) click on the cell to include in the formula (it can be on another
sheet or even another workbook)
3) type in your operator (+)
4) click on the next cell
5) continue until done - do not type an operator after the last cell

eg =Sheet1!B5+Sheet2!B5+Sheet3!B5+'This is Sheet 4'!B5

 

[Teethless mama]

=SUM(Sheet1:Sheet3!G5)

 

[Gord Dibben]

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