Hello,

I have a workbook containing sheets A, B, C, ... as well as an evaluation sheet.
A, B, C are congruently set-up.

On the evaluation sheet, I'd like to have a data validation drop down fulfilling two requirements:

1. Contains "A", "B", "C", ... (and more, if sheets are added) as content to choose
2. If e.g. "B", is chosen, all formulas of the evaluation sheet shall adapt accordingly: =SUM(B!B3:B7) (choosing "A" leads to "=SUM(A!B3:B7)"

As the INDIRECT functions decrease the speed of the file, a VBA solution is preferred.

Can anybody help me?

Thank you very much for every hint

Florian