Multiple Pivot table in different tabs from one pivot source(source data extended to colum

Dear Experts ,

Can anyone explain me to write to macro to create multiple Pivot table in different tabs from one pivot source ( My pivot source extended to two work sheet since excell row limitation of 65K). I have attached excel files and insert two pivot tables as I required.
I have variable from X1 to X33 in my rows and I need pivot table Name in Row label, Time in Colum label and X1 in Values Field (value filed must be summarized as Sum)
I need 33 Pivot tables in different tabs while keeping constant Row label and Colum label as name and time , and changing value field (value filed must be summarized as Sum) from X1 to X33.

I have inserted two pivot table for get it clear my requirement.

Note
Earlier AlphaFrog from this foram has given below macro. But my Pivot source extended to two work sheet since excell limitation of 65K rows.
So Experts pls extend your support for edit the macro.

Please Login or Register  to view this content.