I have a summary sheet with all my products listed and in 15 other sheets I
have a blank purchase order with a quanties column and a product column. As I
fill out the P.O.'s in all 15 sheets with amounts of a certain product I need
to find that product in the columns from all the tabs and sum the amounts to
my summary sheet. Can this be done?
Summary Sheet
A1 is product item
B1 in the total amount ordered from P.O.
A2 is a different product item
B2 is the total from P.O.
so on and so on for all products

P.O. sheets
A1 is the amount ordered
B1 is a product from any of the items from my product list
this P.O. sheet has about 15 rows in it.