can I use CONCAT to name a table or array in a VLOOKUP formula?

I've attached a sample workbook which has several tables (one table per worksheet). The "ALL" worksheet has a column of names in column Q which I want to use in VLOOKUP formulas, to identify which table (or array) referred to.

Each of the other worksheets has a name matching those in column Q.

An example worksheet name (also seen in column Q) is AlpSie. An example table might be AlpSie!$A2:$F286.

I've tried using CONCAT in a VLOOKUP formula to identify the table name. Thus, if cell Q4 in the "ALL" worksheet is AlpSie, I've tried

Please Login or Register  to view this content.

This doesn't work. I've tried other variations, moving the quotation marks around, or separating the "!" into its own txt string, but nothing so far works.

Perhaps there's an entirely different, more efficient solution to this problem which uses MATCH or some other formula? Any thoughts? Thanks.

Thank you Ali!