Is there any way to make a macro automatically "follow" changes to the
worksheet itself?

For example, I might have a macro with an instruction such as

Range("C5") = x

But then I need to modify the sheet and insert columns and/or rows that
requires the value 'x' to now appear in G9 but I have to manually change the
macro instructions.

I'm sure that there must be a way to avoid this hassle but how?

TIA
Stella