Text in a combined spreadsheet
 

I'm creating a short workbookfrom cells in another book (not owned by me).
In the other workbook, new rows are regularly added so the cell numbering
doesn't remain constant. I'm trying to add a 'comments' cell into my
workbook/worksheet, but because the cell references aren't staying the same,
each time I open it the comments are against the wrong row. Any suggestions
on how to get round this?