Kinda surprised no one mentioned this—use Excel’s Power Query!
Go to Data > Get Data > From File > From Folder, point it to your search directory.
It’ll load all files, and you can filter/sort before importing. A bit more setup, but super powerful for recurring needs.
Go to Data > Get Data > From File > From Folder, point it to your search directory.
It’ll load all files, and you can filter/sort before importing. A bit more setup, but super powerful for recurring needs.
