I am trying to build a project tracking system using Excel. The master sheet
includes "status" spaces that would link to update-able cells status cells in
individual project worksheets. I want to link the master's "status" cells to
the ADDRESS of the status cells in the other worksheet-- not to the
information in the cell, but to the address, so that as the one changes, so
does the other. As it stands, I find that the status cells in the master
"follow" the original information in the individual worksheets around, so
that if an individual sheet is updated, the master continues to show the old
information. How do I get around this?

Thanks in advance.

Clarification: Updating the info will involve inserting a new line each time,
moving the old info down. This is where I'm having the problem.

"Non-profit guy" wrote:

I am trying to build a project tracking system using Excel. The master sheet
includes "status" spaces that would link to update-able cells status cells in
individual project worksheets. I want to link the master's "status" cells to
the ADDRESS of the status cells in the other worksheet-- not to the
information in the cell, but to the address, so that as the one changes, so
does the other. As it stands, I find that the status cells in the master
"follow" the original information in the individual worksheets around, so
that if an individual sheet is updated, the master continues to show the old
information. How do I get around this?

Thanks in advance.