Split Names From 1 Cell To Many

Is it possible to copy specific names based on cell content?

For example:
If I have a cell containing text and the names Bob, Mary, Bill,

I would like have a macro read the contents of the cell, find each name "Bob", "Mary", "Bill", then write their names in the first available cells to the right.

ie: If Cell A1 contains Bob, Mary, Bill
write the names in the next available cells ( in any order)

Cell B1 = Bob
Cell C1 = Mary
Call D1 = Bill

It would be great if this can be done within a range..

If anywhere A1:A100 contains the names Bob, Mary, Bill,
to write the names Bob, Mary, Bill ,in their next available cells.

Also, I have a few dozen names that i'll be incorporating in my worksheet which I'm hoping to expand on.