Excel file merge with different headers but same data
I suggest SSIS (SQL Server Integration Services) . 
It is designed for handling collecting data  from different sources and export  to database.
You can design a simple data flow and run it from SQL serevr on schedule (daily in your case)