Your CountYesJohn macro can be reduced to: 
Sub CountYesJohn()
With Sheets("Report_Results")
  Worksheets("JD").Range("B2") = Application.CountIfs(.Range("B9:B679"), "Doe, John", .Range("L9:L679"), "Yes")
End With
End Sub
It should be easy to adjust your other macros.
But does this need a macro? You can put the formula:
=COUNTIFS(Report_Results!$B$9:$B$679,"Doe, John",Report_Results!$L$9:$L$679,"Yes")
in cell B2 of sheet JD.

It can be easier than that; if you have in cell B1 of the JD sheet "Doe, John" instead of the current "John Doe", your formula could become:
=COUNTIFS(Report_Results!$B$9:$B$679,$B$1,Report_Results!$L$9:$L$679,"Yes")
which means the formula in cell B2 wouldn't change from sheet to sheet.

One last question, I see you have the words 'Filtered Yes Count'; does this mean you're going to filter the table in the Report_Results sheet at some point and only want a count of the visible results?