VBA Auto sorting help

[JustTheTim]

I have a workbook with 5 different sheets, 4 of them I'm attempting to have automatically sorted by name but for now i'm only focusing on sheets 1 and 2. I have the macro for Sheet 1 to auto sort and it works perfectly. Sheet 2 has the names across columns instead of rows. The names for sheet 2 are populated by referencing sheet 1. The names by themselves already sort since I have the macro for sheet 1. My issue is getting all the data in the rest of the column to move with the names. Names are list from B2 through X2 (no header). The data for each column starts in row 3 and goes to row 64.