Jump to chart sheet using macros and hyperlinks

I have been trying to easily hyperlink to a chart sheet and have found a simple solution but would like to simplify it further for future use.

Right now I am using:

Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
Sheets(Target.TextToDisplay).Select
End Sub

(Note: the link location doesn't matter)
Now when I create a hyperlink using the create hyperlink function and set the Text to Display as the chart sheet name this works.
However when I use a formula and set the [friendly_name] to the same value as I would enter into Text to Display the marco does not work.

If anyone knows the difference between [friendly_name] & Text to Display or has an easy alternative solution I would be very appreciative.

I have and that works with the macro.

However I am unable to create that insert/hyperlink by simply copying the previous cell or having it insert itself automatically.

That's why I was trying to use the hyperlink formula but it doesn't seem to read the cell/hyperlink as TextToDisplay.