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.

Hi royUK

The workbook was this way when I got it, with many sheets that is.
I will get more workbooks like this so I guess I just have to deal with it this way.

The links are just simple hyperlinks, not written or done with any VBA.