That work perfectly. Now the next step would be to use that to create
a sort of index. The tab names are listed in column A. Using the
hyperlink function in column B, it would create a hyperlink to the tab
based on whats in column A. I thought I could use a combination of
hyperlink and indirect, but I think my syntax is wrong (?)

=HYPERLINK(INDIRECT(""#'"&A1&"'!A1""),"Cell1"), where Tab1 is typed in
the A1 cell

Any ideas?