Referencing another sheet and moving rows

Hi everyone,

I'm trying to improve a spreadsheet we use at work and have been facing a very annoying problem.

We have a file with multiple sheets that account for where our clients are. They can be on the waiting list, allocated or discharged, and they will be moved through. That part works fine.

However, we're now trying to integrate another file, that includes the status for when they should be contacted (since we contact everyone that is on the waiting list every 3 months). To solve that, without including that on the main sheet, since with the number of columns we have that would be very annoying, we created a new one just for the calls.

We are now referencing some data from the other sheet, such as name, client id, why they are with us for and a few others. Then we include the progress of those calls. The issue is, when someone is moved (say waiting list to allocated), the call status remains on the same row, and then they are not matching the right person anymore.

If anyone can help shed light on that issue, I'd be extremely grateful.