I have a workbook that we use for our internal customers to use to place orders for equipment. There are five worksheets within that file that outline the different products. The requestor will indicate what items they want by putting a number in the quantity cell that is appropriate for the product. This could be using a combination of all five worksheets for the one request.

What I want to do is to create a summary page that only extracts the information from the other worksheets that has a value marked in the quantity spot only.

Can this be done?

Many thanks in advance.