Create multiple pivot table in one worksheet based on different data

[hwopt]

Hi, Gurus,

How do I write out the command for creating multiple pivot table based on data in different worksheet in vba ?


Hereby, i attached my excel file
I wanted to create multiple pivot table using vba coding in the "Pivot" worksheet based on "ESI, ESA, EKA , EKY" data
meaning i need to create 4 pivot tables in one "Pivot" worksheet

Is there any way, i can command it to automatically go thru each worksheet detect the data from each row and column, then create pivot table with one row spacing, then create another pivot table based on the data attached ?

PLease help


ThNKS

[hwopt]

please anyone know the command ?
I am out of my wits