I'm trying to write a macro or something that will be able to link to a
cell's data even if it moves. For example, if i have data in A2: "Office1"
and i want cell E3 to link to that data. Now, if the original data in A2
moves, i want the link to follow where it moves to. If i moved the linked
cell, E3 i want the link to stay at the original A2, or where it moves to.
does this make sense?

Thanks!