No different file types. Just seperate sheets for each day. Formula looks like:

='Monday'!B9&CHAR(10)&'Tuesday'!B9&CHAR(10)&'Wedne sday'!B9&CHAR(10)&'Thursday'!B9&CHAR(10)&'Friday'! B9

But not every row will have 5 lines of text all the time, so I was trying to
find a way to make it resize the height automatically.

"DNA" wrote:

Just curious, "how" is it coming in (i.e., from what other application or
file type)?