I have past experience in combining excel & inputing data, when I was working for S&P global as financial modeling associate, we were given projects where we needed to consolidate different excel(of different financial Model)to one as per client requirements.
Feel free to contact me.
Regards,
Lakshya