Subsequent to using the 'show pages' function on a pivot table, I have a
workbook with multiple worksheets of pivots.

I would like to paste-special values on all worksheets so they can no longer
be manipulated by the pivot. Then copy a pre-defined format to all
worksheets.

Bonus question: Would it be possible to systematically add data validation
dropdowns to the first two columns of each of these newly created worksheets?

Any help would be greatly appreciated.

Thanks,
Singh