Hello, I have a query from a Folder that has three excel files. The query works, but only if all the .xls files have the same worksheet name.
I will likely have many files over time in the Folder & don't want to have to change it every time.

Does anyone know how I can change the query function to get around this worksheet reference?