You don't need to use a function. Just type = followed by your cell
reference. So for your example, in Cell D6 on Sheet 2 enter the formula:

=Sheet1!B4

This will also work with numbers. You only need to use the SUM function
when you want to add a range of cells.

HTH,
Elkar

"Golden Knight" wrote:

I want to move names from one worksheet to another by referencing cells. I
know that =SUM moves numbers but I can't get any of the other functions to
move a name from Worksheet One cell B4 to Worksheet Two cell D6.