Yes, a simple example

=Sheet2!A1

in other words just preced the cell ref with the sheet name and !. If the
sheet has embedded spaces, enclose in single quotes, such as

='This Sheet'!A1

--
HTH

Bob Phillips

"Jeffrey" wrote in message
...
Can you create a formula to pull from one worksheet to another, both
within
the same file?