Thread: Naming the Pivot tables

I am creating a lot of pivot tables. Can I choose them from a drop down or list and have it change in the same worksheet.

I want to avoid having too many worksheets.

Thanks

you should be able to create multiple pivot tables on one worksheet
providing you leave enougk rows between them for possible expansion
you could then hyperlink to each table