Hi,

I have 5 worksheets, labelled A-E.

Is it possible to build a formula which references the same cell in any one
of these worksheets by have A-E in cells A1, meaning that if I cahange the
value in A1 to either of the 5 letters, the result reflects the value in that
specific worksheet

cheers
pepperds