Marco for changing numerous pivot chart filters at once

Hello all

First off, I would like to mention that I am a rookie when it comes to VBA.

I am trying to change numerous pivot table filters (which are connected to charts) all at once. Specifically, I would like to change the "Month" filter. For example, changing the filter from "September" data to "October."

I'm looking for a relatively simple code to do this. It would be ideal if I could create a data validated cell which would change all the filters as I selected the corresponding month.

Thanks in advance

Thank you WasWodge, but this code was too complicated for me to figure out.

I solved the problem using the Slicer option in excel with all pivot tables. Of course, the solution was so simple.