Create multiple pivot tables from pivot cache

Hello Expert,

I have following VBA code which allow to create pivot table on new worksheet.
Q: How can i create multiple pivot tables from existing pivot cache on new worksheet?
I have tried several option but failed to produce any solution.
I hope someone help me out.
Thanks,

Please Login or Register  to view this content.