copy columns based on another

[matthew123456789]

Sorry if this is pretty simple, but I'm struggling to find what I'm looking for.

I want to create a totals page based off of multiple other sheets.

sheet 1
find a specfic name between a2:a7
once that name is found, take the data from the corresponding row (where the name is) in both B2:B7 and c2:c7 and take it to another page.

The data in a2:a7 can be in different orders, so I need to find the specific name in that range and then move the data in that row to a totals page.

do the exact same thing for sheet 2 and so on.

in the example:
Find Ainslee, take her Game 1 and Game 2 score and show it on the totals page

WEST	GAME 1	GAME 2	SERIES
Natalie	116​	103​	219​
Macy	126​	116​	242​
Ainslee	184​	195​	379​
Reese	107​	121​	228​
Addison	171​	126​	297​
Callie	171​	161​	332​

Thanks in advance for the help!!!

 

[kevin9999]

Not 100% sure exactly what you're looking for, but is this somewhere close?
Sheet1

Book1
	A	B	C	D
1	WEST	GAME 1	GAME 2	SERIES
2	Reese	107	121	228
3	Natalie	116	103	219
4	Macy	126	116	242
5	Callie	171	161	3
6	Ainslee	184	195	379
7	Addison	171	126	297
Sheet1

Sheet2

Book1
	A	B	C	D
1	WEST	GAME 1	GAME 2	SERIES
2	Addison	171	126	297
3	Ainslee	184	195	379
4	Callie	171	161	3
5	Macy	126	116	242
6	Natalie	116	103	219
7	Reese	107	121	228
Sheet2

Totals sheet:

Book1
	A	B	C	D
1	WEST	GAME 1	GAME 2	SERIES
2	Natalie	232	206	438
3	Macy	252	232	484
4	Ainslee	368	390	758
5	Reese	214	242	456
6	Addison	342	252	594
7	Callie	342	322	6
Totals

Cell Formulas
Range	Formula
B2:D7	B2	=SUMPRODUCT(--(Sheet1!$A:$A=$A2),Sheet1!B:B)+SUMPRODUCT(--(Sheet2!$A:$A=$A2),Sheet2!B:B)

 

[Peter_SSs]

Welcome to the MrExcel board!

in the example:
Find Ainslee, take her Game 1 and Game 2 score and show it on the totals page

Like Kevin, I am not entirely sure but is this the sort of thing you mean?

matthew123456789.xlsm
	A	B	C	D
1	WEST	GAME 1	GAME 2	SERIES
2	Natalie	116	103	219
3	Macy	126	116	242
4	Ainslee	184	195	379
5	Reese	107	121	228
6	Addison	171	126	297
7	Callie	171	161	332
Sheet1

matthew123456789.xlsm
	A	B	C
1	NAME	GAME 1	GAME 2
2	Addison	171	126
3	Ainslee	184	195
4	Callie	171	161
5	Macy	126	116
6	Natalie	116	103
7	Reese	107	121
Totals

Cell Formulas
Range	Formula
B2:C7	B2	=FILTER(Sheet1!B$2:C$7,Sheet1!A$2:A$7=A2)
Dynamic array formulas.