help: need spreadsheet that you specify number of teams in group then displays win loss

Hi all,
What i'm looking to do is create a spreadsheet where the first page allows me to input the number of teams in the group.
The teams cannot play others in the group except the ones they are paired with.
eg. "Enter number of team pairs in set" (in this case 4)
Team 1a vs Team 1b
Team 2a vs Team 2b
Team 3a vs Team 3b
Team 4a vs Team 4b

After number of teams in set is established click a start button on the first tab of the spreadsheet.

this auto generates a new tab with all the possible win/loss combinations of 4 team pairs.
New Picture.jpg


if the number of teams on Tab 1 is changed (say to 6) and the start button is clicked, another new tab is generated with all possible win loss combinations of a 6 team set.

Is this possible? and how easy would it be?
remember 1a vs 1b can only be win or lose
and the win lose combinations are for the set of 4 matches ( or more matches if specified on the first tab and clicked).
if you put 7 in for the number of team pairs then it would be win loss combos for 7 pairs of teams.
Thank you in advance.
mrhempNew Picture.jpg

Tried it, and getting a Run-Time error "1004"
Application-Defined or Object-defined error at the following line.

With Range(Cells(Rw, Col), Cells(Rw + Pairs - 1, Col + 1))

But thanks for the help
mrhemp

Tried it, and getting a Run-Time error "1004"
Application-Defined or Object-defined error at the following line.

With Range(Cells(Rw, Col), Cells(Rw + Pairs - 1, Col + 1))

But thanks for the help
mrhemp

Awesome! Worked perfectly!! how would I change the subroutine if I wanted to change the number of teams to 5 pairs, 6 pairs or 7 pairs?

I admit VBA code is over my head, the only programming I ever did was BASIC back in the '80's lol.

Oh I see! change the reference number on the first tab and re-run!
You my friend are an absolute genius!!

mrhemp