Ok advanced question here:

I've got multiple sheets. They all have the same row / column layout and do basically the same thing.

The reason I have different sheets is they represent different product categories. Becuase of this the calculations are slightly different in the same cells across the different sheets.

What I'd like to do is have one sheet has all the user inputs, layout, comments, etc and have the calculations elsewhere.

So basically when a user selects a product category different elements (formulas, etc) on the sheet change to fit that product category.

Is there a way to do this with out using LOOKUP, LINKING, or simular on every cell to every different product category.

Ideally something on the sheet that when you select a category from the dropdown it replaces an etire predefinded area of the same worksheet with a similar sized/formated section (formulas,formating, and all) from elsewhere in the same sheet or on a different sheet in the same workbook.

Whats the cleanest easiet way to do this. I really wanted to avoid hundreds of nested LOOKUPS and/or LINKS.

Thanks much!