increment value of a row in a sheet based on the value from another sheet

Hi guys,

Below is my request:
I currently have a sheet named "A" with columns as: Name, Status. Status column have many statuses like: started, in progress, testing

I want to code the macro in such a way that it creates a new sheet with all the names from sheet A in a column and another column "status". Now, rows of "status" column should show the count if any of the status from sheet A matches.

For example, for Name John, the status are: In Progress, testing. So the result should be:
Name Status
John 2

I appreciate your help on this.