Is it possible to hyperlink a cell to switch to another worksheet within the same workbook?

Ive got a summary of some regions like 'Asia' 'Europe' etc, and would like it so when I double click on the cell it switches to the corresponding region.

Im not too excel savy, and google is overcomplicating things. Is it something I can do using a function or is it something like a macro?

Create a new sheet called TOC

List the sheet names in it

right click on the tab TOC and choose "View Code"

Paste this in:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Row >= 5 And Target.Row <= 12 And Target.Value <> "" And Target.Cells.Count = 1 Then Sheets(Target.Value).Select
End Sub

Change the 5 and the 12 in the code to the start and end rows of your toc

If you have a lot of sheets and don't want to list them manually, paste this code and run it

Sub ListSheets()
Dim WS As Worksheet
For Each WS In Worksheets
Sheets("TOC").Range("A" & Range("A" & Rows.Count).End(xlUp).Row + 1).Formula = WS.Name
Next
End Sub

sifn't pivot table that bad boy

Hell yeah