Macro / VBA Hyperlink Cell reference

Hi Everyone,

I was just wondering if anyone is able to provide me with a macro, which would be able to convert a specific cell text in to a hyperlink which goes straight to the sheet it was typed & referenced to.

For example, Cell A2 description is "C27" which links to a seperate sheet called C27. If I were doing this manually, I would have to click on the cell A2, click edit hyperlink > place in this document > Cell reference > C27. I am just looking for a way to save doing these steps.

Thanks a lot for the help!