Hello there

I would like to do something like this:

in sheet1 the value of cell A1="sheet2"
in sheet1 the formula in cell B1 should be something like:

='A1!'C5

so that it will look in sheet2 because that's the value in A1.

Doesn't work, does it?

Thanks

Peter