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