No VB needed.
There is a simple function to solve it:
Indirect (cell address).
Still, you need to put your full address in your first cell.
If you don't want to bother with putting the column letter in there, you can concatenate two columns, one of them being your fixed data column, and then hide the ones you don't want to see.
Look here an example:
Use B1 to enter your data cell address and hide A1 and C1.