Hyperlinking based on Cell value

Hello,

I have a file with a summary tab and many tabs beyond that for account reconciliation purposes. I have hyperlinks to the specific tabs from the summary page however sometimes the links break. I am looking for a simple macro that when a user is on the cell with the broken link they just click a button and it resets the link based on the cell value you are on which is the tab name. So in other words I just want to pass the active cell text which equals the tab name into the hyperlinking.