Data Validation - Find and Replace? (Dashboard)

So I'm not 100% sure if Data Validation is the way to go about this or if there's an easier way to accomplish what I'm trying to do at all. Essentially, I'm trying to build somewhat of a custom dashboard where I'm able to select a name from the dropdown, and populate the metrics below associated with that name. Hard part is, this data is all based off of seven yes/no questions so it's not a simple math formula. Yes being the positive, no being the negative. This is what I have set up so far for the beginning stage of this dashboard (the empty space to the right of the percentages is where I'd like to put total averages month over month for the name selected in a line graph, right now it's just calculating ALL totals in my workbook).

Bob 57% Total Avg.

Total Avg. per Question

Question 1: 33%
Question 2: 67%
Question 3: 33%
Question 4: 67%
Question 5: 67%
Question 6: 67%
Question 7: 67%


Right now, the cells with percentages are populating with this formula: =COUNTIFS(Sheet18!A:A,"Bob",Sheet18!C:C,"Yes")/COUNTIF(Sheet18!A:A,"Bob"). The data is being grabbed from another raw data sheet. The "Total Avg" cell is simply just averaging the column of per question averages.

The cell with "Bob" is obviously where the data validation is with a list of other names. I'm relatively new to data validation so I'm assuming there's a way to make this happen; but again, being new to this feature, I may be a tad over-ambitious. Any help is greatly appreciate. I've attached a sample workbook to this post. Please don't be afraid to call me names and tell me I'm insane if that happens to be the case here.

Thanks all!

Just replace "Bob" by B2, no quotes. Assuming that B2 is the DV cell.

The cell with Bob already contains the DV. I'm just curious if there's a way I can change the metrics based off of who I have selected from the list by referencing the raw data sheet.

I am a little bemused by what you are asking. B2 does not appear to contain Data Validation, at least, in your example. You can, indeed type a name there but it has no effect on anything because all the formulae are hard coded and refer to "Bob". Hence suggesting you amend the formulae.

That said, even then, it has no effect on your chart because the data range refers to the dates and total percentages on the Raw Data worksheet.

Right. I think maybe I explained it a little too poorly. I left the formula in there to show what it is I'm trying to accomplish. What I'd like to figure out, is how to alter those metrics to reflect what name is chosen via the dropdown. I'm not sure how to make that happen and I can't seem to find the information I need anywhere.