Trying to lock an entire row together for sorting.

I'm sure this is an easy thing to do. What I have is a sheet where I record results from a race. It calculates the lowest 4 out of 5 scores for the event. Now comes the fun part. The participants name is in a merged cell beside the data,and what I need to be able to do is sort the results from lowest score to highest score and have their name move with the sorting.

Each sheet is for a separate class, so it does not need to sort between sheets.

That sounds right in my head, lol.

TIA