Excel consumables price/quote list

I want to get a spreadsheet that will calculate my sell prices of consumables automatically while taking into account the following variables: multiple suppliers of the same products (but they have different ordering codes) Multiple freight costs from different suppliers - and cost amortised over the volume of cartridges they order (more they buy, less they pay freight) Various markup levels depending on client, (4 levels of pricing markup at this stage) One spreadsheet with multiple workbooks - one workbook per client - could be 100 clients or more A formatted workbook per client that I can easily email to them (xls) with their default pricing for the printers they have already, hiding all costs/calculations - that client can enter their quantites they want and send us the sheet for us to process (manually at this stage) - same sheet I can use to quote customers.. I am doing this to ensure that selling consumables I am making a profit at all volumes I sell and prices are consistent when quoting.. Sample spreadsheet attached - I simply don't have the time to do this myself..