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!

Hyperlink does not seem to work on spill array.
Try this in A2 and copy down.

=LET(
   a,FILTER($C$1:$Q$1,$C$1:$Q$1<>""),
   b,ADDRESS(1,FILTER(COLUMN($C$1:$Q$1),$C$1:$Q$1<>"")),
   c,SORT(TOCOL(a)),
   d,TOCOL(SORTBY(b,a)),
   IFERROR(HYPERLINK("#"&INDEX(d,ROW()-1,1),INDEX(c,ROW()-1,1)),"")
)

Thank you so much! Awesome solution.

You are welcome.