This video shows you how to use PowerQuery to combine multiple files within the same folder. Once the query has been set up users can add more files to the same folder and Excel will automatically import the new data and pivot it accordingly.
------------------------