Alpha sort by multiple column ranges

[doug5jmp]

In one sheet I have three lists A,B,C

Each List has name 4 names
A
Mike
Larry
JOe
JOhn

B
Adam
Gary
Frank
Perry

C
Doug
Jason
Matt
Kerry

My problem is that I have data in columns B:EF for each of the names "rows".

I would like to be able to change a name in the list...from one list to another for example or delete and retype, and have each range IE list perform an alpha sort by column A. Though I would like each list to sort within itself NOT all (3) lists combined.

I have a sheet of all (3) lists and the dedicated names alone. I would like to change these names on said list and then report to sheet2 the names alpha sorted within each list and have the entire row sort as well

 

[AlphaFrog]

Excel Workbook
	A	B	C	D
1	List A
2	Mike	Mike1	Mike2	Mike3
3	Larry	Larry1	Larry2	Larry3
4	JOe	Joe1	Joe2	Joe3
5	JOhn	John1	John2	John3
6
7	List B
8	Adam	Adam1	Adam2	Adam3
9	Gary	Gary1	Gary2	Gary3
10	Frank	Frank1	Frank2	Frank3
11	Perry	Perry1	Perry2	Perry3
12
13	List C
14	Doug	Doug1	Doug2	Doug3
15	Jason	Jason1	Jason2	Jason3
16	Matt	Matt1	Matt2	Matt3
17	Kerry	Kerry1	Kerry2	Kerry3
Sheet1

Excel Workbook
	A	B	C	D
1	List A
2	JOe	Joe1	Joe2	Joe3
3	Larry	Larry1	Larry2	Larry3
4	Mike	Mike1	Mike2	Mike3
5	JOhn	John1	John2	John3
6
7	List B
8	Frank	Frank1	Frank2	Frank3
9	Gary	Gary1	Gary2	Gary3
10	Perry	Perry1	Perry2	Perry3
11
12
13	List C
14	Kerry	Kerry1	Kerry2	Kerry3
15	Doug	Doug1	Doug2	Doug3
16	Matt	Matt1	Matt2	Matt3
17	Jason	Jason1	Jason2	Jason3
Sheet2

Cell Formulas
Range	Formula
B2	=IF(A2="","",VLOOKUP($A2,Sheet1!$A$2:$D$5, COLUMN(B$1),0))
B3	=IF(A3="","",VLOOKUP($A3,Sheet1!$A$2:$D$5, COLUMN(B$1),0))
B4	=IF(A4="","",VLOOKUP($A4,Sheet1!$A$2:$D$5, COLUMN(B$1),0))
B5	=IF(A5="","",VLOOKUP($A5,Sheet1!$A$2:$D$5, COLUMN(B$1),0))
B8	=IF(A8="","",VLOOKUP($A8,Sheet1!$A$8:$D$11, COLUMN(B$1),0))
B9	=IF(A9="","",VLOOKUP($A9,Sheet1!$A$8:$D$11, COLUMN(B$1),0))
B10	=IF(A10="","",VLOOKUP($A10,Sheet1!$A$8:$D$11, COLUMN(B$1),0))
B11	=IF(A11="","",VLOOKUP($A11,Sheet1!$A$8:$D$11, COLUMN(B$1),0))
B14	=IF(A14="","",VLOOKUP($A14,Sheet1!$A$14:$D$17, COLUMN(B$1),0))
B15	=IF(A15="","",VLOOKUP($A15,Sheet1!$A$14:$D$17, COLUMN(B$1),0))
B16	=IF(A16="","",VLOOKUP($A16,Sheet1!$A$14:$D$17, COLUMN(B$1),0))
B17	=IF(A17="","",VLOOKUP($A17,Sheet1!$A$14:$D$17, COLUMN(B$1),0))
C2	=IF(B2="","",VLOOKUP($A2,Sheet1!$A$2:$D$5, COLUMN(C$1),0))
C3	=IF(B3="","",VLOOKUP($A3,Sheet1!$A$2:$D$5, COLUMN(C$1),0))
C4	=IF(B4="","",VLOOKUP($A4,Sheet1!$A$2:$D$5, COLUMN(C$1),0))
C5	=IF(B5="","",VLOOKUP($A5,Sheet1!$A$2:$D$5, COLUMN(C$1),0))
C8	=IF(B8="","",VLOOKUP($A8,Sheet1!$A$8:$D$11, COLUMN(C$1),0))
C9	=IF(B9="","",VLOOKUP($A9,Sheet1!$A$8:$D$11, COLUMN(C$1),0))
C10	=IF(B10="","",VLOOKUP($A10,Sheet1!$A$8:$D$11, COLUMN(C$1),0))
C11	=IF(B11="","",VLOOKUP($A11,Sheet1!$A$8:$D$11, COLUMN(C$1),0))
C14	=IF(B14="","",VLOOKUP($A14,Sheet1!$A$14:$D$17, COLUMN(C$1),0))
C15	=IF(B15="","",VLOOKUP($A15,Sheet1!$A$14:$D$17, COLUMN(C$1),0))
C16	=IF(B16="","",VLOOKUP($A16,Sheet1!$A$14:$D$17, COLUMN(C$1),0))
C17	=IF(B17="","",VLOOKUP($A17,Sheet1!$A$14:$D$17, COLUMN(C$1),0))
D2	=IF(C2="","",VLOOKUP($A2,Sheet1!$A$2:$D$5, COLUMN(D$1),0))
D3	=IF(C3="","",VLOOKUP($A3,Sheet1!$A$2:$D$5, COLUMN(D$1),0))
D4	=IF(C4="","",VLOOKUP($A4,Sheet1!$A$2:$D$5, COLUMN(D$1),0))
D5	=IF(C5="","",VLOOKUP($A5,Sheet1!$A$2:$D$5, COLUMN(D$1),0))
D8	=IF(C8="","",VLOOKUP($A8,Sheet1!$A$8:$D$11, COLUMN(D$1),0))
D9	=IF(C9="","",VLOOKUP($A9,Sheet1!$A$8:$D$11, COLUMN(D$1),0))
D10	=IF(C10="","",VLOOKUP($A10,Sheet1!$A$8:$D$11, COLUMN(D$1),0))
D11	=IF(C11="","",VLOOKUP($A11,Sheet1!$A$8:$D$11, COLUMN(D$1),0))
D14	=IF(C14="","",VLOOKUP($A14,Sheet1!$A$14:$D$17, COLUMN(D$1),0))
D15	=IF(C15="","",VLOOKUP($A15,Sheet1!$A$14:$D$17, COLUMN(D$1),0))
D16	=IF(C16="","",VLOOKUP($A16,Sheet1!$A$14:$D$17, COLUMN(D$1),0))
D17	=IF(C17="","",VLOOKUP($A17,Sheet1!$A$14:$D$17, COLUMN(D$1),0))