list data on summary sheet from multiple sheets, based on parameters

Hello,

I am looking for help with pulling data from various sheets and combining into one summary worksheet.
I have attached the file for reference.

For this example, what I am trying to achieve is list all glass tag #’s (with width, height) on the summary sheet but for Floor 7 only. In the various worksheets, the quantity of each tag on floor 7 is listed in column N. Currently, I have a Macro that lists all glass tags on the summary sheet and then have a lookup in Column F of the summary sheet to populate the order qty based on the Column input. However, this of course lists ALL glass tags from each sheet, even the tags with quantity of 0 on floor 7 (rows 11 through 31 on summary worksheet, for example)

Is there a way to have the summary worksheet populate with only glass tag’s that have quantities required for that specific floor? (in this case, only paste glass tag if the value in column N of that row is non-zero) I would like it so that once it is set up the same template file can be used to retrieve the order quantities from different floors

Apologies in advance if any of the above is unclear, I have done my best to describe the situation.

Thanks so much for the assistance!

Thank you so much for your help!

This does work for what I am looking for. One more question (if beggars can be choosers ), is it possible to have the 'total order quantity' populate automatically on the summary tab based on the entered floor number, or is it necessary to enter the column letter for the vlookup to find the order quantity?

Thanks again!

Thanks for that solution!

That works as intended, except for one situation. Not in my example file, but it is possible for the Total Qty listed in column G does not match the quantity required for the specific floor.

So rather than having the value from column G put into column F of the summary page, when '6' is entered as the floor number, I would like the value from column M put into column F of the summary page. When '7' is entered as the floor number, I want the value from column N put into column F of the summary page.

I had tried to accomplish this using the vlookup formula in column F of the summary page but am wondering if it is possible to accomplish with code and then the user just has to push the button and enter in the floor number, not also the column letter in K3.

Thanks so much for your help and patience as I am not experienced with vba!