Keep it simple ..

Since all your sheets are 99.9% identically structured
Just use link formulas to pick up the row totals from each of Sheet1/2/3,

In Sheet4,
In C6: =Sheet1!W6
Copy down to C8

In E6: =Sheet2!W6
Copy down to E8

In G6: =Sheet3!Y6
Copy down to G8

The above completes it for your Income section

You could then copy the top row, ie copy C6:G6, and paste it below for the
other rows for the rest of the items for all the other sections
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
---
"MelSmith" wrote:
Hope this worked for you. Never used that before.
Note: Worksheets 1,2,3 daily income and expenditure worksheets. Each column
and row have their won totals. I want to be able to put a sum on worksheet
4's total column that will add up the totals of worksheet 1,2,3's rows and
columns.

http://freefilehosting.net/download/44g14