Help in preparing the sales summary report

Hello Saviours,

I need help in preparing a sales dash board. I have attached raw date and the dashboard. I need a macro in preparing the dashboard from the raw data. Customer database is another report where we need to vlookup for presence of customer number.
I tried doing it by recording but continuously getting error. So i want to leave it to the Pros of this community. Below are the details of the sheet and dashboard

1. Dashboard - Final Outcome
2. Master Sheet - This is the base sheet with all details for the dashboard. We do pivot from this and copy to dashboard and do conditional formatting
3. Customer database - This sheet is required for table 3 in dashboard. We will Vlookup if the customer number is present in this.

PLs ping back in case of any doubts