Finding lowest cost price with multiple criteria

I've created a very basic spreadsheet to show the data that i am trying to use and the end result that i am after.
On the page titled Pricing (FOB & Landed) there is a table containing part codes by supplier, location and cost.
What i'm trying to do is insert a formula into the next two worksheets, to find which is the lowest cost for each specific product, from each location where the goods are manufactured.
This will then allow we to calculate what my final/best landed cost in the UK is.

Hopefully this explains in a bit more detail exactly what i'm trying to do.

Thanks.