Example 22.xlsm

That makes perfect sense, thank you so much for the help!

So my final question is, if I have two or more names in different cells and need to go into the same cell on a different tab how would I go about doing that?

See attached for example.

Cheers