multiple pivot tables to a worksheet VBA

[Bootney2022]

I create a Survey report every day

Question I have a datasheet with 25 question each answer is given 1 out of 5
(Strongly Agree, Agree, Neither Agree or disagree, Disagree and Strongly disagree)

I would like a macro to create 25 Pivot tables with the results on a single worksheet

Is this possible???

 

[BSALV]

if you do so every day, why don't you make a great table(=database) and add every day's answers to that database.
Then you can use the same pivottable(s) every day and with the help of slicers, select on or more days.

 

[Bootney2022]

if you do so every day, why don't you make a great table(=database) and add every day's answers to that database.
Then you can use the same pivottable(s) every day and with the help of slicers, select on or more days.

Hi below is a mock up to what I need

 

[BSALV]

great !
Add a date in front of your data and add that date in the page-range of the pivottables and add a slicer also with that date.

Otherwise "Copyas" your file, clear the old data, add the new and refreshall.