Such jobs are my daily practice. I plan to complete the project via writing an Excel macro contained in a separate XLSM file. This approach makes further use of the macro very convenient by offering a Control sheet to identify the current input and output files, active controls, etc. A possible approach could be to copy all daily files in a folder, the macro shall consolidate all files in that folder. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees.
Regards!