hope you can help me!

i have one workbook, two worksheets

in the first worksheet i have a list of names
in the second a list of names with outcomes.
the second sheet has many of the same names, with different outcomes.

I would like to find, if the name matches the one on the first sheet how
many records there are for this name and display a summary for different
outcomes.

thank you.