Rollover text from one multi-lined cell to other cells

I'm having a hard time putting into words what I want to do, so i put it into a demo spreadsheet.

Basically, I have a userform that will "input" a multi-lined entry into one cell. I want to use other cells, on a different sheet, that will allow the text to "roll over" into different columns, thus making it easier to read.

Is there a formula that can accomplish this?