Macro to merge data?

[CarJon0767]

Hi Everyone,

I have two sheets in my. The first sheet includes a list of all of the items that have been used in the second sheet. The second sheet contains all of the parts used. I would like to for the first sheet to show name of part and unit price that was used in the second sheet.

[tangangtanga]

Please attached a sample file. Thank you