Taking Content Of Columns And Returning In New Sheets

I've got the following scenario:A sheet (Sheet1) with some columns that look like this:Billy

Bobby
Sally
Joe

C
D
C
D

[Code] ........

I have a second sheet (Sheet 2) that looks like this:

Totals
Billy
Bobby
Combined
Billy Score
Bobby Score
Billy Cumul Score
Bobby Cumul Score

-blank-
C
C
CC
3
3
3
3

[Code] .......

Columns 4 through 8 are automatically populated via formulas I've created, after Columns 2 and 3 are filled. What I would like is a macro that does the following:

Copy the data from the first column ('Billy') in Sheet 1 and put it into the second column of Sheet 2Copy the data from the second column in Sheet 1 ('Bobby') and put it into the third column of SheetNow my formulas will populate the other columns.Take these "results", all of the info currently in Sheet 2, and then paste (values only) them into a new sheet called "[Sheet1.B1] x [Sheet1.C1]" in this example, it would be "Billy x Bobby" 4. Repeat with every combination of non-duplicated column match-ups (every column gets matched with every column once, and once only):

a. Billy x Bobbyb. Billy x Sallyc. Billy x Joed. Bobby x Sallye. Bobby x Joef. Sally x Joe

So, in the end there would be a workbook with 8 sheets.