No doubt you are now goggling "Worksheet_SelectionChange event".

With that you can use a macro and refer to the sheets by their "codename", then it doesn't matter what the tab name gets changed to, you would always be dealing with the same sheet.