Is it possible to use concatenate to create a dynamic link to another worksheet?

[ajava]

In a cell, I have the following link on Sheet2: =Sheet1!N3

Also on Sheet2, I have the value N in cell A1. I want to change N to O in cell A1, and have that change the link syntax (so, it would read =Sheet1!O3).

I know I could simply use Edit/Replace, but I'd rather just change the column reference in cell A1 and have it update all links that reference N.

Possible with concatenate or indirect??

Thanks!!

[Andrew-R]

Is it just a case of changing your formula to:

=INDIRECT("Sheet1!" & A1 & "3")

[ajava]

YES!! That's it exactly!! Thank you - I couldn't get the syntax right in order for INDIRECT to work. Now it works perfectly!!