=SUM(first:last!Range)

the easy way is from the summary sheet click the first sheets tab, hold down
shift and click the last sheet tab, then on that last sheets select the 33X5
range, then finish by pressing enter and excel will insert the closing
parenthesis

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"Phil" wrote in message
...
I have 5 workbooks each with 6 worksheets. Each worksheet has 33 rows and 5
columns with data (numbers). How do I add the 6 worksheets into one monthly
summary? New to Excel so any help will be appreciated. Thanks.

Phil B.

--