Calculate bridge results

[nvdijk]

Hello, my wife and I (Willeke and Nico) like to play bridge. We have a weekly card afternoon with about 8 couples, and in the evening we send the results by email.
This is done using the attached file. However, if I try to sort the accompanying bridge results by the order of any column, the data disappears.
Now I have to cut and paste line by line to put it in a certain order.
Do you have an idea how I can have Excel do the sorting without the data disappearing?

Update:

I have already improved something on the file myself, perhaps it can be made a little simpler, do you have any ideas?

Thank you in advance!

Bridge-scores 20240123 (2).xlsm
Bridge-scores 20240123.xlsm