I have a worksheet where I'd like to create multiple pivot tables (Each on a new worksheet) from the same set of raw data. I also want the ability to easily create new PVT tables, as required (without having to re-select the same exact data). I tried creating a macro (using the recorder), but couldn't do it.

Any suggestions?