Hi,
I don't know if I totally understand what you want to do but you can use

=sum(sheet1!A1:T1)+sum(sheet2!b1:d1)

or if the totals you want to summarize are in the same row in all worksheets

=SUM(Sheet1:Sheet3!B12:E12)

being sheet1 the first sheet and sheet3 the last one

"Banker" wrote:

I need to take the information from multiple worksheets and summarize into
another worksheet. I know how to set up one cell at a time onto the Summary
Worksheet but is there a way to do large areas of cells at one time??