Help w/ selectively combining data

Hello. I am working on a price comparison spreadsheet that requires updating annually. In the past I have done this manually, I was hoping I could automate this process, yet I am not sure how to start.

The spreadsheet I am working on has selected part #'s from 2 manufacturers. I have each manufacturers price sheet in Excel also. My challenge is how to get Excel to find the price cell for each of the selected part #'s, and insert the price into the corresponding price cell in the comparison spreadsheet.

Seems like it should possible, can anyone point me in the right direction?

Thanks

This might be what you are looking for (see encl. pictures)

Ola Sandström


Note:
The two workbooks are placed in the same folder (on the desktop)