Transporting sum from one sheet to another sheet in same workbook

[Bourbon]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

How do I transport the sum (from one cell) of one sheet to another sheet in same workbook. i.e. Workbook called "Budget". Within the Budget Workbook there are several sheets entitled, e.g. "Housing"; "Personal"; "Pet Expenses"; "Medical Expenses" etc. I would like to transport each of the total expenses in a separate sheet within the same workbook called "Budget Summary" . The grand total of all expenses can then be made on the Summary Budget sheet.

 

[JE McGimpsey]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

How do I transport the sum (from one cell) of one sheet to another sheet in
same workbook. i.e. Workbook called "Budget". Within the Budget Workbook
there are several sheets entitled, e.g. "Housing"; "Personal"; "Pet
Expenses"; "Medical Expenses" etc. I would like to transport each of the
total expenses in a separate sheet within the same workbook called "Budget
Summary" . The grand total of all expenses can then be made on the Summary
Budget sheet.

One way:

On a cell in sheet Summary Budget (where total cell in sheet "Housing"
is J10):

=Housing!J10