Using dropdown to filter multiple pivot charts

[diakhaba14]

I have a dashboard with data from multiple countries. Some data is qualitative and I'm using Vlookup formulas to display it, so we have cell dropdowns that populate the dashboard. Other data is from 4 different pivot charts (one data table). I'd like the pivot chart data to filter based on the drop down selection rather than have the cell dropdown and a slicer. Currently, the cell dropdown is on one sheet, the pivot charts on another, and the pivot tables/data source on a third sheet. I've tried a few different resources with no luck on VBA codes. Any suggestions on codes would be super helpful! Thank you.