Hello All! Tyler here! New! Hi!

I'm looking to Create One List from multiple columns/sheets on Sheet 1 without spaces between columns or sheets. They don't have to be in order for now, just all collected into one nice list.

Example

Sheet 2:
Column 1:


1
13

Column 2: (Empty)

Column 3:
3
5

Sheet 3:
Column 1:
1
1
1


I'm looking for a formula that would show Sheet 1's First Column to be:
1
13
3
5
1
1
1


Is this possible? Without empty spaces in between?

Any references?

Thanks!

https://support.office.com/en-us/art...e-e55b20cda2ef ? ?

I'm stumped.