Need VBA code to create dashboard from pivot with condition criteria

[julielara]

Dear experts

I have data table with pivot, i want create dashboard with constraint conditions of date and validation.

i have PivotTable2 with count which need to copy and paste into dashboard sheet with out Sat and Sun if sat and sun come include count in friday

with pivottable3 with sum which need to copy and paste into dashboard sheet without sat and sun if sat and sun come include count in friday.

Pivottable4 with Demat Prep need to copy and paste count and sum section of dashboard.

Default add BG count is 2"
GCOA Non Commercial from sheet GCOA_NON-Commer Total=GAO+GCOA

PivotTable5 & PivotTable6 count and sum into dashboard1 and 2

find the attachment

[julielara]

any experts help on this?