Summary tab

My company uses a spreadsheet for ordering, different types of material on different tabs. I want to create another tab that will summarise the order. So I'm thinking I would need a formula that looks in the quantity tab for data and if it finds anything, would return the contents of the whole row.

Any help?

Thanks for the reply.

You guys are so helpful.

workbook attached

So basically you enter quantities into the first 3 sheets and the output is the grocery list sheet.

so, is it possible?

Are you expecting the solution to provide both the quantity and product in the Grocery List i.e. it is blank to start? Or will it have pre-defined list of products? And can the same product appear more once in a "product" tab?

I am working off of an existing spreadsheet for ordering electrical materials, different types on different tabs. So on one tab is all the plastic conduit fittings, another metal conduit fittings, etc. So when I do an order, I am filling in quantities on more than one tab. But I would like to be able to view and print the entire order in one place for receiving etc.

so John, yes the grocery list is blank to start. And the vegetable, fruit tabs have all the products but no quantities. this blank order form is a template. I open a new spreadsheet from the template and fill in quantities, and I would like the grocery list to fill in the entire order. I am not sure if a product will appear more then once on different tabs. Would that be an issue?

Can Excel even accomplish this or is this more of an Access application? I am hoping Excel can because then I can just modify the existing template and I'm done.