Get a list with each name once
Next to each name the formula is =COUNTIF(range with the names in the worksheet, cell with the name)
Make sure the range is locked.
For example, if the names you want to count are in C1:C100, and you have a list of names in column E, then F1 would be = COUNTIF($C$1:$C$100,E1)