Creating a MPS (Mater production schedule) in excel VBA

[Ynss]

Hello I hope you are well

so for my graduation project I want to create an MPS (master production schedule)

then the problems that our customers send excel files which different then it is necessary each time to put data manually

that's why I want to load these excel files and copy them automatically for each customer and do the necessary calculations (Prevention for 3 months) ( Total surface, Assembly, Process, tools) from a database to display it on a global dashboard

Inputs:

File Order Book.xlsx

Outputs:

Dashboard that displays all the necessary information

Given:

Database