Excel Report Automation (MRP knowledge required, pls watch video for bidding)

I need an Excel task automated. Currently, I manually generate reports, which involves importing, manipulating, and exporting data.

Material: the heads up video regarding to this video is uploaded in Youtube via Link here: https://www.youtube.com/watch?v=EXBV80rS6ls

For those who interested, pls finish to watch the video first. We can continue to talk about the detail requirement once your price & timeline is within our budget and scope.

Requirements:
- Automate the report generation process
- Ensure the fixed format is maintained

Ideal skills and experience:
- Proficiency in Excel, particularly in automation tools like VBA or Power Query
- Experience in data manipulation and report generation
- Attention to detail to maintain fixed formats

Looking forward to your proposals!