Having a column populate specific cells with an identifying characteristic

Hello Excel Help!

I am attempting to minimize the time spent searching through my work's active employee list. My job has a master spreadsheet in Excel that breaks down each department, and in each department each shift, and then each employee assigned to that department and that shift. There are also a large variety of Temp employee's that are scattered through this list. The Temp employees are identified by which vendor they're attached to with a simple identifier, usually the first letter of their staffing agency in parenthesis. (Ex: (D))

I would like to create a column for each of the vendors that my company utilizes, and have it populate with the Temp employee's that we have in our master spreadsheet. I have attempted this myself, but I am unable to get the list to look "clean". It will populate the names, but only in the cells in the same row in the designated column I have chosen. (ie: A4 will populate into J4 if that is the column I have designated)

I would also love to find a way to copy the temp employee into the column along with their current job assignment. The employees are listed under their respective job's in varying places on the master spreadsheet, and if at all possible I would love to be able to borrow the temp employee along with their assignment to one place for quick reference.

I greatly appreciate any help!

Thank You