Hello,

I have multiple sheets, each named after the corresponding month. On each
row, I have an account number, with a list of different data listed across in
the same row. What I am trying to do is have certain cells refer to other
cells on a different sheet. For example, November!c5 would get the number for
October!g5 (all in the same row). With an exact copy, I have found that
=INDIRECT("'"&$C$2&"'!g"&ROW()) does what I want. The problem is, my file is
constantly growing, and I am constantly inserting new rows for new accounts.
When I do this, each account will get incorrect information from the row
above. Is there a way I can use vlookup or another function to make sure the
same information is pulled for each client, even after new rows are inserted.

Thanks in advance.