addition using multiple worksheets

Hi folks, my first post here so don't knock me to much if I'm in the wrong place.
My problem is this
I need to know how to do some addition using multiple worksheets.This is my example.

sheet1 in cells B2 to G2 I have a number
in worksheet2 I am using cells B5 to G5 in each cell I have another number
How do I create a formula to add all these up.

If the different worksheets were using the same cells I can do it but because they are using different cell I can't.I am using ver 2003.
Thanks for any answers.
Nige.

On the TOTALS page, cell B2, enter this:

=SUM(SUMIF(INDIRECT("Shop"&{1,2,3}&"!A1:A50"),"="&$A2,INDIRECT("Shop"&{1,2,3}&"!B1:B50")))
...and copy down that column.

In C2, you'll need to edit slightly as shown, then copy down column C:
=SUM(SUMIF(INDIRECT("Shop"&{1,2,3}&"!A1:A50"),"="&$A2,INDIRECT("Shop"&{1,2,3}&"!C1:C50")))

Continue adjusting for each column and copy down.

By drag, what I meant was having put the formula in the top left cell, hovering your cursor over the bottom right corner of that cell you will see the pointer icon turning into a cross - left click and drag across the columns. This will transfer the formula across into the adjacent column (correctly).

You can then add the relevant formula into the first column of row 2,3,4 etc and repeat the process...

p.s. In tha example worksheet I had already dragged the formula across for you, maybe that's what was confusing you?

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.