Build me an excel dashboard

I have a very simple excel spreadsheet to record continuous improvement activities that occur during our field work. I would like a dashboard built for it on excel to make this data more visual with the ability to filter results. 1. in the tab 'CI data' colum A is where customer name is put in. Need to make sure that this field can only be populated by a customer name that is already present in the 'customer' tab. If it is a new customer need to add that in the customer tab first. The customer tab needs to be searchable. This is just to make sure people do not enter multiple variations of the same customer name into the spreadsheet. 2. The Dashboard The filter drop down would be by customer. So you select the customer whose data you want to display. then you select the time period you want to filter the data by. Then you can tick the displays you want to see which would be: - number of value adds and breakdown of type of value adds. (i.e 20 value adds, 4 cost, 10 social 6 cultural)(as per the drop down in 'CI data' colum D. - total cost saving to that customer over the period of time selected