Formula to help mail merge

I have attached part of the workbook. The first sheet is the original order and the first column contains the numbers I want the formula to calulate so it can be sorted as it is in the second sheet.

You can see that seat 1 for Chemistry (SS) is no 1 and seat two is 9 and so it will appear in the same place but on page two as there are 8 records for sheet.