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!!