Unfortunately, the macro recorder does not use loops or variables...as far as i know. I have accomplished the task of using the same pivot cache to produce two pivot tables, although not simultaneously. Currently, my macro creates a pivot table, copys/pastes to a new sheet, then clears the pivot table fields and creates a new pivot table without reselecting the data, and finally copys/pastes to the recently created sheet.

I want the macro to use loops and variables because soon i will want it to create three or more tables.