Daily Website Data Aggregator

I am looking for a professional who can download multiple excel files from various websites on a daily basis, merge them into a single file, and apply a date column generation based on a reference number from the source files.

Key Tasks:
- Download Excel Files: Daily retrieval of multiple Excel files from designated websites.
- Combine Excel Files: Merge all downloaded files into a single, comprehensive Excel sheet.
- Date Column Generation: Using a reference number from the source files, ensure a new column with the corresponding date is added to the combined file.

Requirements:
- Data Analysis: The purpose of this data aggregation is for statistical analysis. Therefore, the freelancer should have a good understanding of data analysis principles and techniques.
- Excel Proficiency: Expertise in Excel is essential as the job involves downloading, merging, and manipulating data within the software.
- Web Scraping: Experience in web scraping will be beneficial, as the job involves extracting data from multiple websites.
- Time Management: Due to the daily nature of the task, the freelancer should be able to efficiently complete the job in a timely manner.

I anticipate this will be a daily requirement and looking for someone who can commit to this long-term project.