How to return to "original" sheet after using a link to a other sheets?

Originally Posted by royUK

This is a bit confusing. Are you using hyperlinks to move to a sheet or VBA?

If you are using VBA then you capture the active sheet's name in a variable, then use this in your go back to code

Option Explicit

Dim sShtNm     As String

Sub GoBack()
    Sheets(sShtNm).Select
End Sub

Sub GoToSht()
    sShtNm = ActiveSheet.Name
    Sheet1.Select
End Sub

Why do you need 200 sheets, seems excessive to me.

Is it possible for me to use this code, or anything like this?
If so, where to put the code so it is executed every time a new sheet in the workbook is activated?