Create excel calculator / formula page (retrieve information, non-repeating dropdowns, display information, etc)

Hello all I have a small project, to create a 'calculator'. I have attached a spreadsheet that sets out what the calculator will look like. It also attempts to explain how it will be made. The data for this calculator is not included, but it will more or less appear as follows: - 10 sheets, each sheet representing a farm - Each farm has a list of flower varieties - Each variety has a number of stem lengths - Each variety has a fixed type and colour Each sheet has repeating data, e.g. a flower variety will be listed 5 times with a different stem length for each listing, each which have a different price. The calculator is described as below. In the calculator you will be able to select a farm from a dropdown. You will then be able to select a flower variety from a dropdown but you will be presented with a non-repeating/no-duplicate list of the flower varieties for the selected farm. The calculator will then display the colour and type of that variety (simply retrieve corresponding information from a sheet). The calculator will then have a dropdown to select the stem length for the variety/farm selected. Again, it will be a non-repeating/no-duplicate list of the stem lengths available for the particular variety in question. You can then input how many stems you want (any integer). The calculator will then calculate the total price for that number of stems by matching the price for the chosen farm/variety/stemlength with the number of stems, and multiplying those two figures. The calculator will then display the currency for the total price, retrieved from the relevant sheet (EUR or USD will be present). There will then be a field that allows you to input the relevant exchange rate. The final field will calculate the total price in AUD (simply multiplying the total price in EUR or USD by the manually inserted exchange rate). I will send the successful applicant the spreadsheet complete with the full data. I am hoping to get a freelancer who can do an additional job pending the success of this one, i.e. there are more parts to the calculator e.g. calculating freight etc. Thank you!