Hyperlinking to hidden sheets

Hello

I’d like to be able to place a hyperlink on a sheet that is pointing at a hidden sheet. When clicked, I’d like to unhide the sheet and jump to it. Is this possible? I’m very new to LibreOffice but I have managed something similar to this in VBA for Excel.

In addition to this, I’d also like to know how to automatically hide a sheet when it’s no longer the sheet I’m looking at. Ultimately I’m trying to have a menu structure without all the clutter of dozens of sheets to sort through, so if anyone can answer my queries then I’d really appreciate it.