Team Progress Dashboard

I'm not sure exactly you want.  You have created a very visually appealing sheet (pictures 1 & 2) but might want to tweak them to be more database like.  By that I would remove the merged cells and enter the month/date on each line and probably remove the monthly total lines.  I would then also try to make all the column headers uniquely named and not have merged cells showing groups ("In-Store_Actual_A" and "In-Store_Actual_B").  Then I would "Format as Table".  I know this may ruin some of 'beauty' you have created but then you will have an actual data table.  You can then use the filters to filter by individuals.  You could also create a separate page with filters and such.