Populate a 2-column list based on highlighted cells

Hey all,

Was wondering if I could get some help with a Macro code that will fill out a 2-column list based off of highlighted cells.

Example:

On one sheet:

John 1A (2A) 3A 4A
Mike 1A 2A 3A 4A
Kate 1A 2A (3A) (4A)

( ) means the cell is highlighted a specific color, lets say purple.

Once I run the macro, it will fill out a list on another sheet based off of who has highlighted cells.

Result:

John 2A
Kate 3A
Kate 4A

Any help with this would be much appreciated, I suck at VB... it takes me hours of fiddling.

Thanks!!!