Formula for updating large volume of retail cost prices

Hi everyone, hoping someone more capable than me can help.

I'm trying to update a load of cost prices for my business - I've exported a list of the products I want to change with the relevant fields as an Excel spreadsheet and I've imported a spreadsheet with updated cost prices onto a separate sheet within the same workbook.

Each product has an order code that matches the product code from the cost price spreadsheet.

Is it possible to use a formula to pull the updated cost price from its sheet and have it populate the relevant field in the product sheet using the order code as an identifier to match the information so I don't have to change them all manually?

There's a few thousand products so any help is greatly appreciated 😅