I desire to create a collection of merged cells (say 5 cells), or a
textbox, which will wordwrap and grow (or autosize) so that all text
is seen on the sheet.

Can anyone assist with instructions on this?