Grocery list

I have a workbook that my company uses for ordering, different materials on different sheets. When we order, we fill in quantities on each sheet, often with quantities on more then one sheet. What I want to be able to do is have a "summary" sheet that has the whole order on it. So I need a way for excel to look in each sheet and if there is a value in the quantity column will copy the row over to the summary sheet.

My original thread in the functions forum is here:

http://www.excelforum.com/excel-form...mmary-tab.html

I have attached a simple sample of what I am trying to do.