I need to reference a list of names in a column in one worksheet to count the
number of times those names occur in a column in another worksheet in the
same workbook.

That is, check the name list and sum the number of times those names occur
in another list.

How do I do this?