Stripping out unneeded lines

Let me preface this by saying I'm a newbie here and NOT an Excel expert despite having used Excel since the 90's.  So please speak slowly. 

What I have is an Excel worksheet that's basically a "master" order form for retail remodel projects.  Right now the form is about 1,900 lines and I'd like to create a new worksheet that contains only the items that have been ordered.  Columns are supplier, quantity ordered, part number, description, price, and calculated total cost for that item.

Would someone be so kind as to point me in the right direction.  I should also add that in another Excel file is a list of items that are on backorder and I would like to add a column to the "parsed" order form indicating which items are on backorder.  I'm thinking (hoping) that's a fairly simple vlookup.

Thanks!