Pulling all unique "Campaign" entries and running some stats?

Hello again Excel Forum!

I've been working on a tester in Excel that will automatically generate some statistics after running a report that I generate on a regular basis. The final thing I need to do is have, under the "Visuals" tab, the ability to choose or enter a campaign in the current report, and have it populate with all unique "ads", and display the impressions totals related to each one, as well as what percentage the impressions are in relation to the impressions total.

I've been having issues with it, mostly due to the fact of being able to change the campaign and have the workbook re-display the updated unique ads and their respective impressions. Any help is immensely appreciated! The workbook is attached, with some values changed to be generic. Thanks again, guys.

QA Tester IV Generic.xlsx

bumping for visibility!