Taking RAW Data and turning into a dashboard

Hey guys,

Questions here. I'm trying to create a customer dashboard by using the information input from RAW Data. I need to have a searchable date range (start and end date) to display the correct data in the dashboard. I've attached the sample spreadsheet. The Dashboard sheet would has the information that needs to be displayed. Any help would be greatly appreciated. Thanks again!


Data Metrics Example Problem.xlsx

Using SUMIFS formula, an example per file attached.