=Sheet1!A2
If you want the cell to be blank if the original cell is blank, then try
=IF(Sheet1!A2="","",Sheet1!A2)
--
David Biddulph

"Moh" wrote in message
...
how can i update information from one work sheet to another without
opening
the other worksheets?
--
thank you