Appending data from XLS files

Sounds to me like you want to use an Append query whose source is a Folder if that makes sense. Couple questions, is that the only XLS file in the folder that day or do these files accrue in that folder? There have been multiple threads in the past on similar issues but to get to the right answer, just need to know a few details. Regardless, Power BI Desktop's Power Query tools should be able to get you there. There is always the option of using something like SSIS to import into a central database as well.