Pivot table from multiple sheets or one large combined table to create pivot table

[mad3]

I have sheets (24) with the same header rows for each team. I want to combine all sheets onto one pivot table or one large table/range to create a league wide pivot table. I have tried consolidated ranges and got a huge sheet with information I couldn't recognize. Below is a snapshot of what each sheet looks like.

gm#	Team	Res	H/A	Inf/Of	Type Event	RP	Hit	Player	Out Prob.	Pos
1	ST.L	W	H	I	HIGH CHOPPER	1	0	Gyorko	70	3B
2	ST.L	W	H	I	SMASH UP MIDDLE	1	0	ARCIA	46	SS
3	ST.L	W	H	I	FLARE	1	0	FREEMAN	66	1B
4	ST.L	W	H	I	SMASH UP MIDDLE	1	0	PANIK	71	2B
4	ST.L	W	H	I	DRILLED DOWN LINE	1	1	FREEMAN	71	1B
5	ST.L	L	A	I	SMASH UP MIDDLE	1	1	PANIK	70	2B

 

[GraH]

I would go by Data, Get & Transform, Data From Workbook, Combine data, load as Pivot Table.
Do have this in your version?