Need Vlookup or Macro Function to take data from tables and generate a list of part number

I have a list of part numbers and prices, as shown in my excel spreadsheet. I would like to take the part numbers that have quantities next to them to be inputed into a separate sheet. This should be able to sort out the parts that are selected from the parts that aren't. This will make it alot easier for me to find exactly what parts & how many I need to order. There is more information in the excel spreadsheet that I attached.

Hopefully I explained it well enough.

Thanks.