VBA help to copy pivot table paste into dashboard sheet with alignment

Dear Experts

I have pivot in sheet with rawdata i want make dashboard table copy into mail,i updating manually takes alot of time to finish, i want vba code to accomplish task in sec i want copy pivot tables and paste into sheet dashboard one by one from cell B4, Second table after first

i want merge value of sum and average in cell from pivot to dashboard like ACC_Bug 552(635)

find the attachment, if you can help in design on range number please help on this

Hi sir, Its works can do cache copy straightaway pivot and paste into dashboard range ,becoz piivot range get extend week by week towards column

need to change range in code manually , to avoid i need this please help on this

thanks

Hello. I attach another way.

You'll notice that, to simplify the code, I've slightly modified the pivot table on the 'Pivot' sheet.

Thanks alot Experts!! Thanks for your time solved