To get the VBA code, please view: https://www.extendoffice.com/documents/excel/4188-how-to-follow-hyperlink-to-hidden-sheet-in-excel.html
Right-click 'Download' and select 'Save Link As' if the file opens in a new tab.