I'm working off two worksheets.

Worksheet 1 data looks like this:

Dept. P/N Discription Lead LeadFree Both
500 X1 TT
500 A1 PCB BLANK x x x
500 B1 FILTER x x
500 XXX3 plate
500 C1 cup x
500 XX2 Tin

Worksheet 2 is this:

P/N Description Lead Lead Free Both
A1 PCB BLANK
B1 FILTER
C1 cup

I need to copy the data in columns D, E and F from worksheet 1 to column C,
D and E on worksheet 2 for each matching p/n.