MRP Showroom Report

We use our ERP software to download and merge several different excel files and merge them into one. I want to simplify the merging of the files so it does not take so long - and in turn, run more frequently. I am not sure that we are using excel in the most productive way. I am looking for a quicker solution/outcome to merge the data.