Uploading data with Power Query from multiple files into a single Excel database is really simple these days. The process is embedded inside Power Query and once the process is set up, it is just a matter of refreshing the query and new data will be instantly imported. The following video takes you through the process from start to finish.
The Excel files required are below are for the video above. Note that the bonus file is for after the process has been completed. Add this at the end before you upload the data and you should get exactly the same result as that achieved in the video.
Bonus File 4 (Changed the numbers slightly)
This blog post is more of a video tutorial as I go through the steps in real time on YouTube. It is a very handy skill to have and should go nicely with your VBA knowledge as I believe this is a cleaner way to upload data. Well done Microsoft.
