Hyperlink Macro that converts a list of sheet names to hyperlinks to the sheets

Hey,

I am having trouble getting a macro to do what I want.

In column A i have a list of the sheet names in the workbook

I need a macro that will take the text from the cell and convert it to a hyperlink to its corresponding sheet

for example in cell A1 there is the text "SP5M"
there is also a sheet named "SP5M"
I want a macro to take the text from the cell that I have selected, tack on the "!A1" so it becomes an address for the sheet and create a hyperlink that displays just the original name...

if that makes sense?