I haven't been able to figure this out yet. I need help with a dropdown menu with information on the same row in multiple columns.

If I select Joseph for A5, I need the rest of his information to fill in B5, C5, D5, etc...
And so on, for the rest of the personnel.

Any and all help would be sincerely appreciated.