Hi folks,

I'm fairly new to the "joys" of Excel and would appreciate some advice.

I have a multi-sheet workbook. Each sheet has a cell (the same cell on
every sheet), let's call it "D2", with a "total" for that sheet.

Is there a *simple* way of adding up all the "D2's" in the workbook and
putting that sum on the last page? Ideally I want it to keep adding up
all the "D2" cells, even when I add new sheets.

At the moment I'm using the old =SUM('sheet1'!D2+'sheet2'!D2) trick,
but I'm getting a bit sick of manually adding sheet names to that
formula!

I'm on Excel Mac, by the way. Dunno if that matters...

TIA!
Jim