Cells Value to Filter Multiple Pivot Tables

[elbarauljr]

Good Evening,

I am trying to find a code that allows the filtering of various Pivot Tables located on different sheets within the same active Workbook.

For example, one of the active Workbook have the following pivot filtering conditions:

Sheet Name "Group"

Sheet Name "Purpose"

Sheet Name "Status"

In those cases what would be the code to allow the various sheets input to filter the intended pivot table(s) ?
Maybe with a working code for the above example, I can expand the code to work with all the files and conditions that I have. Any assistance would be greatly appreciated, thank you.