formula that advances
 

Hello,

I have a worker who wants to put a formula in a cell that will show up on
another worksheet. But since there are several worksheets for the same
client-but different addresses- the formula will have to advance to the next
cell to collect the correct address.
For example, the first address is in cell A1, and a formula is put in the
corresponding spreadsheet referring to cell A1. But the next worksheet will
need refer to cell A2-that contains a different address. And so on and so on.

Does anyone know how to write the formula to advance a cell? Is this even
possible?