Need help with which function to use.

Col A is labeled addresses in cell A1.
Col B is labeled Team 1 in cell B1
Col C is labeled Team 2 in cell C1
Team 3 in cell D1 etc. 12 teams

Cells A2 thru A50 contain e-mail addresses of players in the teams.
Cols B, C, D etc contain names for each player corresponding to their
e-mail address in Col A. Tom might be in cell B2 and Bill might be in B4,
Fred in B 27. Sam is in C6 and Tom is in C 9 etc.

How can I sort and group the players addresses from each team farther down
in Col A? Example, stating in cell A 55, I list addresses from players in
Col B, so in A55 would be Toms address and in A56 would be Bills address
etc. Farther on down Col A, I would list addresses from Col C etc, then
from Col C etc.







--
remej