I have been working with pivot tables a lot recently. I needed to duplicated a lot at once to get a some work done quickly. To do it i right clicked on the sheet tab at the base of the sheet and selected copy.

You could get a load out this way but if you wanted a lot more just record a new macro to do this.

i.e. Tools Macro record new macro.

go through the step of copying the sheet with the pivot table on.

Tools Macro stop recording.

create a button
assign the macro to that button, you can then press that to create a load of copys.