Macro or Command?

[cgreen]

I have 14 tabs (one for each team). There is 26 weeks of play. On each teams tab I have week 1, week 2, week 3, etc. in column ‘A’. Column ‘B’ has total wins and column ‘C’ has total penalties (all of the teams’ tabs are set up the same way).
Example:
A2 = week 1 (1)
B2 = week wins (5)
C2 = week penalties (1)

A9 = week 2 (2)
B2 = week wins (3)
C2 = week penalties (0)

A16 = week 3 (3)
B16 = week wins (8)
C16 = week penalties (2)

This goes on until the last entry

A177 = week 26 (26)
B177 = week wins (2)
C177 = week penalties (0)

I have a main tab that brings over totals from other columns for each team. On ‘U1’, of the main tab, I enter what week we are in (1, 2,…. 26). On my main tab, when I enter the week number, I want it to grab the information from each teams tab for the corresponding week. The information I want is the ‘week wins’ and ‘week penalties’ from each teams tab to show on my main tab.

 

[paliman]

Libro1
	A	B	C	D	E	F	G
1	Team1	Totalwins	Totalpenalties		Team2	Totalwins	Totalpenalties
2	Week1	5	1		Week1	6	0
3	Week2	3	0		Week2	1	3
4	Week3	8	2		Week3	2	5
5
6
7
8	Week	2
9		Totalwins	Totalpenalties
10	Team1	3	0
11	Team2	1	3
Hoja1

 

[paliman]

Libro1
	A	B	C	D	E	F	G
1	Team1	Totalwins	Totalpenalties		Team2	Totalwins	Totalpenalties
2	Week1	5	1		Week1	6	0
3	Week2	3	0		Week2	1	3
4	Week3	8	2		Week3	2	5
5
6
7
8	Week	2
9		Totalwins	Totalpenalties
10	Team1	3	0
11	Team2	1	3
Hoja1

 

[cgreen]

Thank you ... it worked great.