Is there a formula to move data from one workbook to another?

[calvr1ch]

Hi

I am not sure if there is a formula or some other way to copy info from one workbook to another.
I have attached the 2 workbooks i am using. What i need to do is insert the prices from the 'prices' spreadsheet into the 'to be priced' spreadsheet.
On the 'to be priced' spreadsheet there could be several rows with the same part number. These will need to be brought across from the priced spreadsheet and inserted into column G on the 'to be priced' matching the part number. Is there anyway i can link the part numbers from each workbook and put the appropriate price into the 'to be priced' workbook?

Prices.xlsx

To be priced.xlsx

I hope this makes sense

[calvr1ch]

Sorry admin... Read it and now changed it.. Thanks

[calvr1ch]

Any ideas would be welcolme