Or just type the equals sign & then click in the cell from which you want to
pick up the data.
--
David Biddulph

"Elkar" wrote in message
...
If there is a space in the name of the worksheet, then you'll have to
enclose
the name in single quotes. For example:

='Sheet 1'!O6

"Marshaann_82" wrote:

I know that this is a really dumb question, but i just can't get it to
work.
I am trying to perform a simple function and it's been a while so i just
can't figure what I'm doing wrong. What I have is a workbook with
several
sheets that are identical. I have a cell where i enter a name and I need
for
that name to automatically be entered into the same cell on each of the
remaining worksheets. I thought that I could enter

=Sheet 1!O6

into the cell that I want to copy to. This is not working. What do I
do?