Excel: How to get address of a refered cell automatically, even after changing it’s absolute address?

is ther any way (i.e. function) to show the address of a certain cell in Excel sheet, even after the user inserts or deletes rows or columns or sorts the sheet? For instance, if a cell address is G10, I see this string (“G10”) in another cell, and after inserting a column between A and B, the string changes to “H10”.

I appreciate any help.