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?