Transfer columns in one column

Hi,
I 'd like to transfer my data from multiple columns into one column, one after the other!
Pls, see attached file!

thanks!

Samle fare filing.xlsx

Let me see if I have this right - You want to move all the columns from C to YY to Sheet 2? Do you mean 'Cut' and 'Paste' or do you want them linked? Not sure I understand your request.

Cheers

Your request is not clear.
You said you want to transfer in to a single column, but you have 3 columns in the output sheet. I followed your sample and did 3 columns only. When you run the code, you get the output in new sheets.

Sorry for not being so clear..
However, AB33 that was exactly what I was looking for!!
Thnaks a lot!