Pivot Table Filter Based on Cell Value

[Studk22]

I have a question in regards to having a pivot table filter change based on a cell's value.

My pivot table name is "Colors", my pivot field name is "Color Names" and the filter is the color available for each commodity which is in cell AJ7.

Do you know how I could link the selection from the data validation list on the "Tool" worksheet to filter the pivot table "Color?" Also, if a macro is the answer do I put this macro in the Worksheet "Tool"?

Thanks for your help!

- Excel Novice