Find name(s) within text string that matches a list, then copy full name

Hey guys. I'm trying to extract first AND last names from a string of text(4000+ rows) and have them copied to a separate cell. The idea is that I can search the text for the first name then simply copy that name and the following string(likely last name).

Anyway, it's not as easy as I thought. Here's what I have so far....

Please Login or Register  to view this content.

I have a list of common names on Sheet2 that the function checks against.

If possible I'd like to copy multiple names. The following is an example strong of text...

Additional information
MSP #29 William Nelson Pres Jessie Nelson Member; Sr V Pres Amber Cave Administrative Assistant

So for that line I'd like to extract "William Nelson" "Jessie Nelson" "Amber Cave", each in separate cells


Thanks ahead of time. This is hurting my brain.

Attached is a sample workbook.

Sample name find.xls