Is there any way to duplicate a pivot table?

Is there anyway to duplicate a pivot table? I have several reports each month that I need a pivot table for, and only need to change source sheet and destination folder. It would save me some time each month if I didn't have to create new ones from scratch. Any ideas?

Answers