Build a quoting Excel spreadsheet to generate price quotes based on the price list, selected quantities and quoting rules

Build an excel spreadsheet that generates price quotes based on the selection criteria. - Spreadsheet contains a workbook-1 with a price list - items and a corresponding price of each item. - A workbook-2 contains “solutions” with a list of supported solutions. Next to each solution, I want to be able to fill in a quantity desired. - There will be a way to tie “solutions” and a corresponding “items” from the price list. Some solutions need more than one item. I need a way to make some of these items required for each solution and others will be optional. I want to have an automatic selection of items based on manually selected solutions and a set of corresponding rules. - Based on the selections and what has been pre-programmed as required or optional, generate a list of all selected items in the workbook 3.