Synchronize Pivot Tables

Hi

Iam trying to find a code to create a table(Excel Table)using data from 2 Pivot tables, where Rowfields and ColumnFields are also include.

Please suggest the code and also what if I have to add data from more Pivot Tables?

Also suggest if .PivotFields(Sum of Budget").Caption = " Budget" is correct code to change column caption in Pivot table?, as it is giving me an error.

Thank You