You can have XL create the link for you automatically.
Then you can copy/revise that syntax to suit your needs.

Click in the target cell of a sheet and hit the equal sign,
Click on the tab of the origin sheet,
Click in the cell containing the data,
Hit <Enter.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Treasur2" wrote in message
...
How do (or what function) do I link worksheets or specific cells in
different
worksheets.