I have a spreadsheet in which Worksheet 1 is a master list of names and group assignments. Worksheet 2 sorts these names into the respective groups. Worksheets 3 and 4 are group specific worksheets, pulling the sorted group lists from worksheet 2 into column A on each respective group worksheet. Attendance Data for each individual is also stored in worksheets 3 and 4. The issue I am having is that as new names are added to the master sheet and sorted alphabetically, they resort alphabetically on worksheets 3 and 4(which is intended); however, the attendance data does not follow the name as it is resorted. What I am wondering is there a way to lock, link, or associate rows of data together so that as new members are added and the main worksheet is resorted, the attendance data on worksheets 3 and 4 follow the name during the sort which occurs on the main worksheet. Stating my problem in another way, the order of the names on worksheets 3 and 4 are dependent upon the order of the names in Worksheet1. Thus, when Worksheet1 is resorted alphabetically after new names are added, the order of the names on Worksheets 3 and 4 are automatically updated, alphabetically. This is intended. The problem is that the attendance data entered in worksheets 3 and 4, columns H through ....., do not remain associated with the correct name (in column A).

It has been suggested that the problem is that I am not selecting entire rows during a sort. This is not the problem as worksheet 1 sorts correctly; however, since the order of the names in columns A on worksheets 3 and 4 are dependent upon the order of the names on worksheet1 they automatically resort themselves in Column A on worksheets 3 and 4. The attendance data for a specific name does not follow the name during the resort, however. The way I am seeing it is that I need to be able to lock rows of data on worksheets 3 and 4 together so that entire rows of data move with the name in Column A. I am assuming I will need a macro to correct this problem; however, I am terrible at writing these. Any help, whether a macro or another solution, is greatly appreciated as a workaround has stumped me for over a month.