random pick names from a list

Assume names are in A1:A24. Put this formula in B1

=RAND()

and copy down to B24

Now sort A1:B24 based on the numbers in column B - that'll give you a random sort - use the first 4 for Team1, next 4 for Team2 etc.