Create hyberlink to sheets based on matching text

[dancingdata]

I have a range of cells which will look as below in the main sheet:

1.1.1-ABC
1.1.2-CDE
1.1.3-EFG


Other sheets name: 1.1.1 , 1.1.2 & 1.1.3

I want a formula to retrieve the numbering text in main sheet and create a hyperlink that match with the text value. So If I clicked on 1.1.1-ABC for example it will go to 1.1.1.

I need to achieve this for a big list of outline numbering

Any ideas?

 

[mrhstn]

Assuming the split is always sheetName-somethingelse, then

Sub Macro1()
Dim lst As Long
Dim i As Long
Dim cellSplit() As String
lst = Range("A" & Rows.Count).End(xlUp).Row
For i = 2 To lst
    cellSplit() = Split(Range("A" & i).Value, "-")
    Sheet1.Hyperlinks.Add Range("A" & i), "", cellSplit(0) & "!A1"
Next i
End Sub

Make sure and test it on a copy/test workbook.

 

[dancingdata]

It works perfectly! Thanks a lot @mrhstn