I'm trying to compile text from multiple worksheets into a column in another
worksheet of the same excel project without having spaces...or repeated
numbers. I'd like it to compile like numbers by itself into a single cell in
the column...for example instead of:

1

2

3

2
1
4

3
I'd like it to be:

1
2
3
4
Anybody know how to do this? It would be greatly appreciated!!