Automate the sheet in order to calculate costs

I have an order sheet and 3 reference sheets. I would like to automate the sheet in order to calculate costs and for selling different types of products.

All the products have reference numbers and costs on one sheet. We also have production costs on another sheet. The production costs are categorized as (high, medium, low). Finally, the shipping costs based on quantities requested.

I would like to be able to:

1. Look up a product based on a product ref and have it return the cost based on that reference number entered into the order sheet.

2.Look up the product type requested and have it return the cost.

3. Enter the quantity of products and have it calculate the cost.


Please feel free to ask questions if you do not understand me.