Do you mean something like =2*Sheet1!A1 ?
This returns twice the value of Sheet1's cell A1
You can type as shown or:
type =2*, open Sheet1 by clicking its tab and click the cell A1
either continue typing, or click the green check mark or use ENTER to finish
the formula

Not that is the sheet's name has a space in it, then it appears as 'January
data'! with single quotes around the name (not the explaination mark!)

Does this answer your question?
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Lexi" wrote in message
ps.com...
How do I take a cell in one worksheet and add it into the formula in a
different worksheet in the same workbook?