reference a value from a different worksheet

[kaplonk]

How do I get a value from one worksheet to another summary type page

 

[Bernard Liengme]

In the summary sheet cell type =
Open the data sheet and click on the cell whose value is needed in the
summary
You see in the formula bar a formula such as =Sheet2!A5
Click the green check mark in the formula bar

OR: need you mean in a different workBOOK.?
Repeat the process to get a formula such as ='[The Source
File.xls]Sheet1'!$C$6

 

[Earl Kiosterud]

In the summary sheet:

=Sheet1!A1
='Sheet 1'!A1

 

[David McRitchie]

Try =Sheet4!A5

For something more creative see
http://www.mvps.org/dmcritchie/excel/buildtoc2.htm

Also look at 3-D references in Help if you want to
combine materia from several sheets into one cell.