I'm developing a reporting pack that references one Excel data list, but
contains 20+ pivots each with different page, row, column and data fields
and some with certain page field values selected.

For time to time, usually when the file gets contaminated with a bug, I have
to manually re-create all the pivots - a manual and painful process.

Does anyone have code for rapidly creating pivots from variables placed in a
single worksheet? I had in mind something similar to John W's custom menu
generator.

Thanks, John