Arthur,
Type and equal sign =, then click on the worksheet from where you want
to pull data and select the cell, and hit enter. Voila! You've just
made a link to another worksheet.
Of course, you may have a different intention, like 'linking' which
rows are active, in which case you'll need to post back.
HTH,
Bernie
MS Excel MVP