AHRI Package Pricing

I work as a TM for a heating and cooling wholesaler, and I'm attempting to create a document that will allow my customers to easily look up "package pricing" depending on the columns in the other sheets.

I am looking to use the data in "sheet1" to match up with the items on the other pages so my customer can see the different cost for the combinations.