✰✰✰ How To Automatically Update a Dashboard Based on Multiple Sheets ✰✰✰

Hello everyone,

For the past few days i am trying to solve a problem for the PPC company that i work. Basically, i am trying to create a Excel dashboard that can sort PPC data, based on other sheets. I have attached the doc to this post, maybe you guys can come with something up.

Here are the things that i am trying to achieve with this dashboard:

- in the dashboard sheet, i want to be able to sort data, based on the "Accounts" sheet;
- in the "Optimization Criteria" field, from the Dashboard sheet, i have added 4 criteria to sort the data:
1. Account - is a validation box that allows me to select through different accounts;
2. Campaign Type - is a validation box that allows me to select through different campaign types;
3. Optimization Type - ------------------------||----------------------------- optimization types;
4. Campaign Issues - ------------------------||----------------------------- campaign issues;

- below the "Optimization Criteria" there is a table. The point for this table, is that whenever i select a account in "the account validation box", i want the data from the "Accounts" sheet, to be automatically added to table.

If, for example i want to sort the account data by campaign type, i would like to see in the table, only the columns for that specific sort i made.
And so on.

Tomorrow is my birthday and if i can get this problem solved, it will be the best gift ever.

Thank you.