I run 13 reports from my Accounting software every morning. I then save them into a folder dated the current date. I would love to generate a macro that would open up all these files at once and copy and paste the data that I need from them into the master file. Is this possible to do?

Here is my sample master file. SAMPLE TEST.xls.

Each one of the tabs has a report that I open. If I could take the data from each one of the reports and copy/paste it into this master file, that would be wonderful! It would cut out a lot of my time and would allow me to be a lot more efficient.