Issues with creating an array of hyperlinks

In my sample workbook (see attached), I have a number of tables organized horizontally across Sheet1. I want cell A2 to contain an alphabetized vertical array containing all table names as hyperlinks. Clicking a hyperlink should direct the user to the appropriate table. The array should expand or shrink as tables are added or removed. Needing a non-VBA solution.

I've made a few attempts using the following formulas, but as you'll see in the attached file, no luck yet :/

=HYPERLINK("#" & ADDRESS(1, COLUMN(C1:Q1)), TRANSPOSE(C1:Q1))

=HYPERLINK("#" & ADDRESS(ROW(C1:Q7), COLUMN(C1:Q7)), C1:Q7)

Thanks in advance for your help!