Hi

I have identical data sets in different worksheets. I have one calculation
worksheet at the front of the workbook and based upon the choice in a drop
down box I want the calculation sheet to reference one of the different data
sets.

I have tried using IF statements and this is ok until you reach 7 worksheets.

Is there a way where I can change the referenced worksheet in the
calculation formulae based upon the choice made in the drop down box?

Any help much appreciated.

Best regards
Dave