Excel DPR Monitoring System Development

I need an Excel-based Daily Production Report (DPR) monitoring system with the following requirements:

1. I have 12 machines running in 3 shifts of 8 hours each.
2. Each machine runs a product (product changes daily).
3. Each product is handled by an operator (operator changes daily).
4. On every machine, downtime occurs (different departments/reasons).
5. On every machine, rejections/waste (lumps) occur (different reasons).
Requirements:
- One Entry Sheet where I will fill day-wise shift production data:
  (Day, Shift, Operator, Product, Machine, Plan Qty, Actual Qty, Lumps, Cycle Time, Downtime Reasons).
- From this Entry Sheet, system should automatically generate separate reports:
  - Operator wise report→ Day wise, which product he ran, on which machine, how much produced, how much rejection, downtime calculation (Plan vs Actual).
  - Product wise report→ Day wise, which machine produced, which operator, production qty, rejection, downtime.
  - Machine wise report→ Day wise, which product ran, which operator, production qty, rejection, downtime.
  - Downtime report → Day wise, split by department-wise downtime reasons with minutes calculation.

Expected Output:
- Fully automated Excel (preferably using Power Query or VBA).
- Just by entering data in Entry Sheet, all other reports update automatically.
- Easy to refresh / update (one-click refresh).
- Simple and clean format.

Please apply only if you are experienced with Excel VBA / Power Query / Automated Reporting.