You can use a 3-D reference, which you can find in your Excel help.

So far you have sheet1, sheet2, sheet3, and sheet4

You can create a sheet0 before sheet1, and
sheet99 after sheet4 -- as seen physically on the worksheet tabs.

in your summary sheet:

V3: =SUM(sheet0:sheet99!V3)

insert any new sheets anywhere between sheet0 and sheet99
The names of the sheets does not matter, as long as you address
The SUM is actually inclusive, so if you had anything in V3 on the end sheets
it would be included in the SUM.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"backtothesky" wrote in message
m...

Can I to get a total from every sheet in a workbook into the last sheet,
while having Excel automatically update when a new sheet is added to the
workbook?

Example: I've got 4 sheets with an amount in cell V3, and I want the
total of all of the V3's to show up in a specific cell on a fifth
sheet. If I add another sheet containing a V3 value, can Excel add that
automatically to the formula on the total sheet? Or do I have to
manually change the formula every time a new sheet is added?


--
backtothesky