How do I Populate Data Across Tabs?

Stephen,
It really shouldn't matter that there are other formulas on the totals that you need. Did you copy and paste that formula? It looks like it is referencing the same sheet. Can you attach a mock-up spreadsheet? I need to see it because I'm perplexed but not ready to give up.

Please save it as an Excel 2003, if you have 2007 (I can't open 2007).

Thanks!

This sounds like what Excel calls a 3-D Reference.

If you look up "refer to the same cell or range on multiple sheets" in the help file it will explain it in detail.

For now, what you need to do is go to the cell on your Misc Calculations sheet where you want the sum to appear, type "=SUM(" then click on the first tab you want summed (eg, Sunday), hold down the Shift key and click on the last tab you want summed (eg, Saturday) then click on the cell you want to be summed in the sheet that is showing (which will be Sunday), press Enter and the correct formula will appear in Misc Calculations.

Codewise, if you wanted the sum of cells K2 to appear in any cell of Misc Calculations, you could write it as:

=SUM('Sunday:Saturday'!K2)