Mass extraction of multiple Pivot table setup conditions

[Shaundal]

I inherited 5 excel files between them have >100 individual pivot tables across multiple worksheets. Some sheets have multiple tables. I’d like to extract the file name, worksheet, cell location and most importantly, pivot table setup conditions (filter selections, rows, columns & values) for every pivot table quickly. So I can assess if multiple pivots can be consolidated into one data extract. TIA!