Try this formula on sheet 1 or any other sheet to mirror what is in a1 of
Sheet 2

=Sheet2!A1

Mike


"nick" wrote:

I would like for a cell in sheet 1 of a workbook to track the contents of a
single cell on sheet 2 of the same workbook.