I'm attempting to create an Excel file where a user could enter a quantity
needed of a particular part number in a column listing of various parts and
then to be able to have only those rows with a quantity entry be consolidated
to a separate sheet...
1 35200 Screen, S.S.
37733 Screen Assembly, Teflon(R)
15 37798W Weep hole union, S.S. 1/4"
37801W Weep hole union, S.S. 3/8"

Ideally, after entering quantities for separate items, I'd like to have only
those items with a quantity value entered be consolidated and reported on one
sheet. I have multiple worksheets with different part numbers and associated
item descriptions and would like to be able for the user to go through the
multiple pertinent worksheets, enter the needed quantities as needed from
each worksheet and then generate a single report detailing only those lines
that have a quantity entered from all worksheets. In the above, my desired
report would reflect--
1 35200 Screen, S.S.
15 37798W Weep hole union, S.S. 1/4"
Can this be done and, if so, how would one set it up?