Formulas link cells
 

I am trying to expand a workbook a previous co-woker started. A page contains
all possible components (ie. bolts). Based on user input, a quantity value is
placed beside the required part number (I have 2 colums, 1 is quantity and 1
is part number on a worksheet). On a seperate worksheet, I want to place on
those rows with a quantity value. How do I write a formula to do this?