I need an Excel for Mac Expert

Im looking to automate a Sales Quotation spreadsheet. Essentially it will be a list of Requirements, Price table, Product specs table, and rule/criteria and a quote page listing the matching products and related price and quantities. We are an all Apple Mac environment so we are restricted to Excel for Mac 2016 functionality unfortunately. (ie All functions, SQL, VBA Marcos etc should work but no Power Pivot and no multi table PowerPivot available.) For Example: Requirements (Drop down Lists) 1 Savings OR 2 Backup OR 3 Both 4 Budget Amount 5 Roof Type Price table 1 Inverter A 2 Inverter B 3 Battery A 4 Battery B 5 Panel A 6 Panel B Product specs table 1 Inverter A (5kw, Max 10 panels, Min 5 panels etc) 2 Inverter B (10kw, Max 20 panels, Min 5 panels etc) ……. Rules/criteria 1 IF Savings THEN Inverter A, No Batt, Panel A 2 IF Backup THEN Inverter B, Batt B, Panel A or B) etc etc Quote page Option A Inverter A R 5000 Panel A R 5000 TOTAL R10000 Option B Inverter B R 5000 Batt B R 2000 TOTAL R 8000