Text to columns for multiple columns

I have data in 40 cells. They are in columns A to D and rows 1 to 10.
I need to Move the data in columns B,C and D so they are only showing in Column A. Text to columns won't move more than one column is there another way to do this as I have about 100 worksheets with similar data so need to be able to do this fairly quickly.

Thanks.

use concatenate function (&).

Thanks but don't see how this can work. Maybe I've not been as clear. See spreadsheet below for example.

Thanks

Good evening Dougie,
try this formula in this website it should sort youre problem .
http://excel.bigresource.com/Track/excel-GcnMdcj7/
Regards
Sem