"jackreacher" wrote:
I am using Excel 2003. I have a workbook to keep track
of daily expense/revenue figures. I have a different
worksheet for each month. At the end of each month I
total each revenue and expense item. I want to have a
year to date figure for each column that carries over
to the next worksheet. How do I do this?

If you are willing to put the subtotals for each month into the same fixed
cell on all worksheets, the solution can be simple. The easiest place is
row 1 (subtotals on top, not on the bottom). That's also most convenient
for the human "computer". For example:

=SUM(Sheet1:Sheet12!B1)-SUM(Sheet1:Sheet12!C1)

where B1 is the subtotal of revenues and C1 is the subtotal of expenses.

Note: Very few functions allow "3D references" like Sheet1:Sheet12!B1. SUM
is one of them.

If you insist on putting the subtotals into difference cells on each
worksheet, there are more robust ways to deal with it. But why bother?
"Everything should be as simple as possible, but not simpler" (Einstein).