Linking Multiple Source Columns To A Single Destination Column

[excelnooby]

From reading other threads, I learned how to reference or link a source column to a destination column on a different sheet within a workbook. ie. =Sheet1!A:A

My question is, How do I link multiple source columns to a single destination column? So any data typed in any of the specified source columns on sheets 1-6 will automatically appear in the next available cell in the destination column for sheet 7.

Kind of like =Sheet1!A:A =Sheet2!A:A =Sheet3!A:A =Sheet4!A:A =Sheet5!A:A, etc... for the destination column.

If I am making any sense.

Thanks.