Reshuffle group combinations without repitition...

Hi all,

I need a help on this one. For me this is way too complicated but I am sure there are enough maestros out here to offer helping hand.

Lets say there are 24 golfers. I want to create six groups of 4 golfers each.

The golfers will play for 4 months. After every week, the golfers get reshuffled so that they don't play with same combination again. So in all there will be sixteen reshufflings in four months.

Is there any faster way to achieve this group of combinations in excel?

Any formula or macro or something? Please help.

Thanks in advance.