Hi,

I hope this question has not been answered. I did search and found some similar questions but could not get any of the solutions to fit my exact situation.

What I want to do is take column 'A' and column 'B' from several worksheets and stack them together in a new worksheet.

IE
Sheet1
A B
-----
1 A
2 A


Sheet2
A B
-----
3 B
4 B
5 B

Sheet 3
A B
-----
6 C
7 C

Stacked into

Sheet4
A B
-----
1 A
2 A
3 B
4 B
5 B
6 C
7 C

Is this possible? I currently just copy and paste it of course but that gets old as we update the information in each sheet quite often.

Thanks in advance!

Michael Stinson