Cost calculator in Excel

Hi, I need to have our cost calculator updated. It is an Excel sheet that we use in the sales process to show the production costs with our system. We need 1 sheet where the customer can choose between different machines (dropdown) and based on the chosen machine, the production costs for this machine must show. All consumables cost are taken from 1 sheet where we can enter these costs. After the machine type has been choosen, we then need to chose the other products (liner, inks, etc.) used in the production from dropdown menu's. Again this data must be taken from one sheet where we enter the costs. I have attached an example of the current - basic - version to give an idea about the kind of tool we need.