Excel Macro to hyperlink an archived worksheet to an index page

[Steve Venianakis]

Hello,
I need a macro to assign to a control button that will create a hyperlink of the worksheet name to a Main page. In addition, it will need to fall within a range down a column, and find the empty cell two rows down from the last entry. For example, the first hyperlink will create on Cell G7, the next hyperlink will create on Cell G9 and so forth.

Thanks to all in advance!