Hi

if the 5 worksheets are similarly structured have a look at data /
consolidate.

basically, in your summary sheet, select a cell, choose data / consolidate,
tick the relevant boxes on the consolidate dialog (if your product numbers
are in a column tick left column - BTW this assumes that you have product &
quantity in adjacent columns) ... then go to the first sheet, click in the
reference line, choose the products & quantites, click ADD, repeat for all
sheets.

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Erika" wrote in message
...
I have 5 different worksheets all listing product number and quantity, on
the
6th worksheet I was to sum all of the quantities of products with similar
product numbers.

So find all of the product number 1ASB on the previous spreadsheet and sum
there quantities

Any ideas on how to do this?