Looking for a formula/solution to return lowest pricing options across multiple sheets.

Sheet = Service Provider Lane Analysis RFQ.xlsx
Columns = Airport location and shipment pricing rates
Rows = Product purchased

I would like to have a table generated on a separate sheet that will allow me to look at all pricing data (excluding $0), and list the lowest price and service provider for each product model shipping to the specific airport. See attached for example. End result will have 7 sheets total.

Thank you for any help you can provide!