I need to have the information that I input into one cell (cell A) link to a
different cell (cell B) and stay permanent into (cell B). Then the
information I put into cell A the next day link to cell C and stay permanent
in cell C. Cell A is alway a working cell and Cell B, C, D, & E and so on
will stay permanent.

Any suggestions?