Format a conditional hyperlink

[Clintypops]

I have a table of data on a worksheet that I add to continually. Column A is a list of account numbers that each have a corresponding tab or worksheet within the same workbook. Is there a way to format column A so that when I paste the weeks data into the table the account numbers will automatically hyperlink and link to their respective tabs?

 

[RasGhul]

Have you got some sample data that you can post?