Expanding cell reference

[Moosgraves]

Hello,

I'm setting up a worksheet that will use cell references to pull information from a separate spreadsheet into my sheet on a monthly basis. However, the problem I'm running into now is that the row I'm pulling info from is never the last row on the referenced sheet (i.e., whomever is creating the other spreadsheet is just using "insert row" and posting their info in between other data).

Is there anyway I can get my sheet to recognize when the additional row has been added or...?

Thank you.

--Andrew

 

[Yard]

Shot in the dark:

Rather than using cell references, try using references to entire columns, viz:

=A:A

rather than

=A1
=A2
=A3

etc

Then it won't matter if someone inserts a row - you'll still pick it up.