I need to create a reference link to use Excel to produce a quotation
calculator. I want a column of Product codes, a colum of cost prices and an
option on margins to be made then a sum at the end. I want to make a sheet
take data from other sheets within the same workbook with dropdown options
i.e. You choose "Product A" from a dropdown list and automatically the cost
price of Product A appears in column B...there is a dropdown menu on column C
offering 15%, 20%, 25% etc. and this will automatically calculate a "Sale
Price" in column D.

Is this possible?