Interactive Dashboard and data filtering

I am trying to create an interactive dashboard but being an unexperienced person with excel functionality I ham facing some challenges and wondering if one of you can help me out.
I am attaching a sample data file that contains two tabs (data and dashboard). By looking at dashboard tab you will know what I am trying to build. Based on the drop down values I would like to populate the data on the dashboard tab.

let me know if its not clear or if you have any questions.

Really appreciate your help!

thanks