group values from 3 different columns when the value in one column is sorted

This workbook has grown to a monster beyond my skill set, and I am hoping there is an excel genius out there who can help. When you open the book you will see 3 teamsheets marked "sequoia teamsheet". "dawn teamsheet", and "coast teamsheet". You can see by the formulae that these teamsheets pull values from the top census sheet, which is and will be the master data entry sheet. At one point I simply imported the data as well as the associated info that I wanted to include into column D, P, and Q. I then learned I needed to truncate the last names for HiPPa laws so you can see an assortment of formulae there now that arrange the names alphabetically according to last name. The problem is that when i do this the values in column P and Q remain as they did originally. What I would like is a formula that keeps the values for column D, P, and Q together even when the value in column D move to another row due to sorting.

Here is an example if you need more clarification: On the top Census sheet you see the patient named "up town" is in room 829-2 (column A) and has 2 CIWA scores - 5,2 (column H). They are on the Sequoia team (column N) so their name will populate on teh Sequoia Teamsheet. When you look at the Sequoia Teamsheet you can see that "up town" is there, but after being sorted the room number and CIWA scores remain in row 4 while "up town" was moved to row 9. How can I keep these values together so that the room number and the CINA/CIWA scores are always in the same row no matter how many times the name is sorted?

by the way...I can add as many columns and/or rows as are needed...I will just hide them before printing.

assuming the patient names are unique you can link columns P & Q to them thus they will stay in the same row when sorted, see attached (highlighted)

whaty a simple and elegant solution. THank you.