I have 5 sheets in one workbook and I want to take two columns from each sheet and put them into one master sheet. These sheets also get updated periodically so I would like the master sheet to be able to reflect those changes
Sheet 1
1 A
2 B
3 C
4 D
5 E
Sheet 2
6 F
7 G
8 H
9 I
10 J
Master
1 A
2 B
3 C
4 D
5 E
6 F
7 G
8 H
9 I
10 J
Can this be done?
Thanks
Sheet 1
1 A
2 B
3 C
4 D
5 E
Sheet 2
6 F
7 G
8 H
9 I
10 J
Master
1 A
2 B
3 C
4 D
5 E
6 F
7 G
8 H
9 I
10 J
Can this be done?
Thanks