Dynamic Hyperlinks to Excel Tabs

I have an Excel workbook that is used to document Test Cases when we do manual testing. The new boss wanted more functionality by having a build in test matrix. I adding all of his requested features except for the hyperlinks to the tabs. I have a button that grabs certain information from each test case and populates it into the matrix, but I have been unable to figure out hoe to turn one piece of that data into a hyperlink. The Matrix is populated dynamically each time the button is pressed, so I can not hard code the tab names explicitly in to the VB editor.