Grouping people and images.

Hi. I need some help to get a nifty solution to this problem.

I have a file with x number of people. lets say 500.
I have cleaned the file up, its adresses hobbys and so on.

Now to the tricky part.

I need to in groups of 6 add names (or in this case images but thats not important) to a placement card.

so lets say i have something that looks like this.

HakanF
AndersJ
SteveS
JohnD
DRcox
KelsoS

Now i want these names or images in this case to work like the following. card 1 (hakanF) should have pictures of the other 5 people at the table. Card 2 should have pictures of the other 5 and so on.
So the table should look something like this (first name being the owner of that placement card)

HakanF - AndersJ - SteveS - JohnD - Drcox - KelsoS
AndersJ - SteveS - JohnD - DrCox - KelsoS - HakanF
SteveS - JohnD - DrCox -KelsoS - HakanF - Anders J

Now making this is not a problem if i should do it by hand but i need to automate this cause it could just as well be 5000 people.
The real problem is the groups of 6 outta 500.

Lets say i have the first row of names in column A (all 500).

Thanks

So no takers on this one?. I could add that the - is just to reference a new cell. the names should all be in a cell of their own.

No, but thanks for replying
Its alot more complicated then that.

Lets assume i have 6 people that needs to be seated around a table. On each of the persons placement card i need pictures of the others around the table (now this has to do with digital print) so the fact thats its images is really irrelevant in this case.

So i have a file with 500 names. they need to be grouped around a table (wich happends to be a table of 6)

so 6 people

HakanF
AndersJ
SteveS
JohnD
DRcox
KelsoS

Now after HakanF the other 5 names should be on the same row (different cells) as i illustrated in my first post.
Just doing cell references wont work cause if i just drag down then the 6'th row will start to include people from table 2.

I can easily give them a table number in groups of 6 but the rest if problematic. Worst case this needs VBA with IF and FOR loops but i suck at scripting

for example the last row with Kelso S would be something like KelsoS - HakanF - Anders J - SteveS - JohnD - Drcox

Actually i solved it. Was easier then i tought so no problem anymore Thanks anyway.