Merging 2 worksheets

I have one worksheet which contains part numbers, description of parts, and quantities(new, used, dmgd-w, dmgd-nw). Worksheet 2 will contain part numbers in a random order and quantities assocaited with each part number.

I want a macro to take the part number from ws2 and find it in ws1. Then I want the macro to enter the quantities from ws2 into ws1 with the corresponding part number.

How can I do this?