Build Spreadsheet with pivot table solution

I have 4 tabs

1 MVD: has VAT number and Vendor number
2 VAT: list of valid VAT numbers
3 VLI: Vendor line items has Vendor number
4 PVT: make me a Pivot Table here include the following;
A) Split between valid and invalid VAT numbered line items
B) Allocated by payments days (clearing date - document date) segmented by
- Within 20 days
- Between 21 - 30 days
- Between 31 - 60 days
- Between 61 - 90 days
- Between 91 - 120 days
- Over 120 days
C) The Percentage of total number of invoices in each segment
D) The Percentage of total value of invoice in each segment (from Amount in DC)
E) I will paste new data in MVD VAT VLI tabs only, please no calculations on these tabs