Greetings friends!
I have a silly request I can't hammer out. I have a workbook with a Template Sheet and an Index Sheet. What I desire is when I create a New Sheet from my Template Sheet, It Creates a Hyperlink on the Index Sheet linking to the New Sheet. I have a column that I wish the Hyperlinks to be populated to on the Index Sheet. The hyperlink text should be the Sheet Name of the New Sheet. Please see my enclosed book for further details. 
forum.ozgrid.com/index.php?attachment/67032/
CTRL+C "Creates a new sheet"
CTRL+H "Renames the Sheet to the Values In F4, F5 and F6" This is also the macro i would like to create the hyperlinks.
Cheers