Random set of lists with item limits

Scratching my head on whether I can do this in Excel:

1. I have a list of 100 unique names.
2. I need to create 100 random lists where each list contains exactly 10 names.
3. But...no name can appear in more than 10 of the 100 lists.

Is this feat doable in Excel?

Thanks...
Gary

Or more than once in any given list?

In A1, enter 1
In A2 and copy down to A10, =MOD(A1, 100) + 1
In B1 and copy to B10:CV10, =MOD(A1, 100) + 1

Presto, 100 lists, all names appear 10 times.

If you want it to look more random than that, there are ways ...