Inventory data to purchase order

I have created a simple spreadsheet to keep track of inventoried parts for my business, including bin #s for location, along with an input cell for the "on hand quanity" from a physical invemtory we take 2 times a month. I have established a "target quanity" column and a column called "to order" which is simply a (target - on hand) calculation. Here is what I'd lie to do. I would like to create a "Purchase Order Sheet" for each of the vendors, and have the quanity to order, part #, Bin number and discription, be listed on the PO sheet, but not sure how to eliminate the blanks caused by the "0 to order" cells. all of data I want on the PO's are already on the basic worksheet already.

I'm not a programmer, but I can find my way around with some direction.

John