Report
 

I have created a spreadsheet with multiple Pivot tables using uniform format
showing months as columns. Individual Pivot tables stored in different
worksheets represent each department. I have created a Standard Report in
the same spreadsheet, to pull the data from Individual Pivot Tables using
Index and Match.I want to know a way of selecting a specific department, so
that the Standard Report will change the data based on the selection,
preferably using a drop-down list.
Thank You for Valuable advice.

Krish