Asuming your first sheet is Sheet1 and you are updating information in cell
A1, then the formula to link to that from another sheet, such as Sheet2 would
be:

=Sheet1!A1

Just repace "Sheet1" with whatever your sheet is named and the cell
reference of A1 to what ever cell or range is applicable.


"Burritto" wrote:

I have a workbook that has several worksheets. I manually update the info in
the back worksheets and have links in certain cells to update the info on the
first worksheet. Is there a way to for the link to update to the latest data
I put in the back sheets so that the link changes to the next line once I
populate it w/data?