So you first want to identify all the names that appear anywhere in the grid of names, ignoring any duplicates. And present that as a list in a separate section of the sheet.
Then you want to count the corresponding number of entries in the grid which match each of the names from step 1. And enter that into your list next to the corresponding name.
Then you want to sort the result so the name with the most entries is the first, and the name with the least entries is last.
Is that an accurate statement of your goal and one approach to solving it?
Said another way, is the goal to “Have a de-duplicated list of names that appear anywhere in the grid, each accompanied by its number of entries in the grid, and with the list of counts + names sorted by number of entries in descending order”?
If you’re willing to manually identify all the names, and enter list of names in your results section of the sheet, having Excel generate the counts are trivial. If your grid is cells B2:F27, then =CountIf(B2:F27, "Carlos Alcaraz") will result in the number of Carlos entries in your grid.
I hope it’s obvious how to generalize that, with a list of names in e.g. column B and a list of CountIf() expressions next to them in column A taking their comparison value from Column B of the same row.
Getting them into sorted order is where it gets hard using just formulas versus macros or pivot tables.