I have a worksheet that gets data from a worksheet in another file. Each
month the cell references have to change to the next row. For example, this
month I'm referencing C134, which is the June line on the other file. Next
month, I need to reference C135, the July line.

How can I automate this? My first thought is to use a macro, but I can't
find an example anywhere of a VBA macro that moves a cell reference to the
next row.

Any suggestions would be appreciated.

Thank you,
Paula