How do I have a linked cell auto-size to fit the linked data?
 

I'm using Excel 2003.

Within a workbook I have a data entry worksheet and several "report"
worksheets. In some cases the data being entered is multiple lines of text.
The cell on the data entry page will automatically re-size to fit all the
lines of text. However, the linked cell on the "report" page does not auto
size and results in the information being cut. I have found that if the data
cell is already populated when the link is established, the report cell will
format to the current cell size. I need this to occur automatically when the
data changes on the data entry page, not just at initial linking.

Any thoughts?