Consolidate multiple columns to one using formulas

Hello,

I have multiple columns that are different in size and that are getting updated from different sheets each time a new value is added.

I am looking for a formula solution that will consolidate them in a single column, one under another. I have a total of 9 columns which differ in the number of rows and will be different in the future as well.

In the attachment I color coded them to be more visible.

Thank you for your help!