Update a sharepoint Excel file with the contents of multiple Excels in another folder

For context we recieve a monthly Excel report every month that is automatically upload to our Sharepoint.

At the moment we have someone manually copy and paste the content from these newly uploaded files into a "master worksheet" that contains all the reports data in a single file. I want to know if there is a way that we that we can automate the process of updating this excl file?

The tabs and columns on all the Excel's are exactly the same.