If you get a #REF! error you presumably don't have a sheet called Sheet3.
If your sheet name includes spaces, you need to surround the sheet name with
single quotes, such as:
='First sheet'!G28
--
David Biddulph

"Patty" wrote in message
...
All I get is a #REF! error.

"Gary''s Student" wrote:

Use a linking formula. For example:
=Sheet3!G28
will get a value from Sheet3 cell G28
--
Gary''s Student - gsnu200817