Splitting data in single column across multiple worksheets

Hi all

I'm trying to find a way to split a single column of data across multiple sheets.

The situation is I have 60 sheets in a workbook all in identical format, with different data.
On a single workbook I would use "text to columns" function and then delimited based on splitting using spacing.
How do I do this across 60 sheets as I would with a single sheet?

Record a macro of you using the text to columns function on one sheet, then put that inside the following:

Please Login or Register  to view this content.