Linking to a sheet based on the contents of a cell Won't pass through a table query

[kolterp]

I am using this formula

= HYPERLINK("[MyFle.xlsm]" & F5 & "!A1","Link")

The above operation works very well. It will not pass through a query. I havemultiple sheets with identical tables on them. From each sheet I am trying topass the above link so my query will link back to the sheet that the table ison.


I understand a pivot table would provide thisfunctionality but I am on a’’ let’s say pretty restricted system and pivottables do not work.


I am able to get all data I need but want the abovefunctionality.


Thanks,


Dave