Excel Append Multiple Ranges into a New Worksheet

[WendyHubard]

Hello,

Trying to help out our game rostering people at the local football association. I've already received assistance in configuring conditional formatting which is working perfect (Thank YOU AGAIN). Now I am trying to total the games for each Division. Once the roster has been entered, there will be approximately 800 rows of data.
I have multiple ranges in my worksheet that I would like to append these ranges into a single table on a new worksheet. Currently as at this stage, I'm trying to muddle my way through it, I have the following Ranges "Game_1", "Game_2" and "Game_3" configured (but will configure for the rest of the Games - once it's working). Each Range contains the same data type, but reference different columns for Game_2, Game_3 (column A, B and C will be in every RANGE plus the GAME details) Etc. I'm hoping that I can then append all the Games onto a new spreadsheet containing 5 Columns and multiple ranges. It's a very long process and the outcome I am hoping to achieve is to see how many times each team plays against each other for all rounds. Any assistance greatly appreciated. - and apologies in advance for my dumbness!

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM
1				Game 1			Game 2			Game 3			Game 4			Game 5			Game 6			Game 7			Game 8			Game 9			Game 10			Game 11			Game 12
2	Round	Date	Ground	Division - Game 1	Game 1 - Team 1	Game 1 - Team 2	Division - Game 2	Game 2 - Team 1	Game 2 - Team 2	Division - Game 3	Game 3 - Team 1	Game 3 - Team 2	Division - Game 4	Game 4 - Team 1	Game 4 - Team 2	Division - Game 5	Game 5 - Team 1	Game 5 - Team 2	Division - Game 6	Game 6 - Team 1	Game 6 - Team 2	Division - Game 7	Game 7 - Team 1	Game 7 - Team 2	Division - Game 8	Game 8 - Team 1	Game 8 - Team 2	Division - Game 9	Game 9 - Team 1	Game 9 - Team 2	Division - Game 10	Game 10 - Team 1	Game 10 - Team 2	Division - Game 11	Game 11 - Team 1	Game 11 - Team 2	Division - Game 12	Game 12 - Team 1	Game 12 - Team 2
3	Round 1	10/04/2020	Windsor Park	Under_9	East Under 9	Prospect Under 9 Gold	Under_10	Deloraine Under 10 Blue	Deloraine Under 10 White	Under_11_Girls	Deloraine Under 11 Girls	East Under 11 Girls	Under_12_Div_1	George Town Under 12	Launceston Under 12 Blue	Under_12_Div_2	East Coast Under 12	Launceston Under 12 White	Under_14_Girls	Deloraine Under 14 Girls	East Under 14 Girls	Under_14_Div_1	East Coast Under 14	East Under 14	Under_14_Div_2	Deloraine Under 14	Launceston Under 14 Blue	Under_16_Div_1	East Coast Under 16	East Under 16	Under_16_Div_2	George Town Under 16	Deloraine Under 16	Under_17_Girls	East Under 17 Girls	Deloraine Under 17 Girls	Under_9	North Under 9 Black	North Under 9 Red
4
5
6
7
8
9
10
11
12
13
Roster - Data Input

This is what i would like it too look like:

Book1
	A	B	C	D	E
1	Column1	Column3	Column4	Column5	Column6
2	Round 1	Windsor Park	Under_10	Deloraine Under 10 Blue	Deloraine Under 10 White
3	Round 1	Windsor Park	Under_11_Girls	Deloraine Under 11 Girls	East Under 11 Girls
4	Round 1	Windsor Park	Under_12_Div_1	George Town Under 12	Launceston Under 12 Blue
5	Round 1	Windsor Park	Under_12_Div_2	East Coast Under 12	Launceston Under 12 White
6	Round 1	Windsor Park	Under_14_Div_1	East Coast Under 14	East Under 14
7	Round 1	Windsor Park	Under_14_Div_2	Deloraine Under 14	Launceston Under 14 Blue
8	Round 1	Windsor Park	Under_14_Girls	Deloraine Under 14 Girls	East Under 14 Girls
9	Round 1	Windsor Park	Under_16_Div_1	East Coast Under 16	East Under 16
10	Round 1	Windsor Park	Under_16_Div_2	George Town Under 16	Deloraine Under 16
11	Round 1	Windsor Park	Under_17_Girls	East Under 17 Girls	Deloraine Under 17 Girls
12	Round 1	Windsor Park	Under_9	East Under 9	Launceston Under 9
13	Round 1	Windsor Park	Under_9	North Under 9 Black	North Under 9 Red
Competition Data