Please be more specific.
Do you, for example, want
1) sheet1A1 + sheet2A1....
or
2) sum( of A1:D10 on every sheet) placed in one cell

tell us more; best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Tracey Jones" wrote in message
...
I have multiple spreadsheets that I want to sum them up on one main
"control" sheet, so I can get a grand total payroll figure. How can I do
that? Any help would be appreciated.

Thanks,
T. Jones