Click in the destination cell, type the = sign to start the formula, then go
to the source sheet and click in the source cell, which will put that
cells's reference into your formula. Hit enter.
--
David Biddulph

"gasman" wrote in message
...
I have created an excel spread sheet, to track data over multiple years.
As
I create a new sheet for a new year, hou do I Import final tallys from the
previous year i n a formula, so I don't have to manually update the
'sheet'! command