Advanced Excel Macros

I am looking for an Intermediate Excel macro developer who can create a macro that will generate a consolidated report based on data from three different excel date formatting report need to calculate ETA. The main task of the macro will be report generation based on date formula, and it will need to be run daily. I already have a specific report template, so the ideal candidate will have experience working with automatic calculating estimated delivery time based on mode level