Please read again what Mike said in his post. Type the = in the formula
cell, then click in your johnsmith A20 cell, & the formula should include
the link correctly.

Presumably ='John Smith'!D13
--
David Biddulph

"Gatsby" wrote in message
...
Thanks for replying, Mike. That doesn't work for me.
John Smith has a space tween John and Smith on the tab. I've tried =John
Smith!D13 and Johnsmith!D13. A box appears "Update Values Book".
I notice in your post you leave out the '!'. I've tried that too.

"Mike" wrote:

Its sounds like you may have some rogue spaces in either the sheet name
or
the formula.

In the formula cell enter = then navigate to johnsmith A20 and see if
that
works.

"Gatsby" wrote:

If I enter =Sheet2!A20 into a cell in another sheet the value appears.
Great!
If I enter =JohnSmith!A20 it doesnt work. Why? It asks for the
location of
John Smith even though his sheet is in same workbook.
Thanks

Gatsby (Not the Great)