If there is no space in the worksheet's name, then this....

=Sheet2!C2

If there is a space in the name, then this...

='Sheet 3'!C2

Rick


"Laurie" wrote in message
...
I have 30 sheets. I would like to have a summary sheet that will return
the
same cell value from each sheet. For instance, I want my summary sheet to
return the values for:

Sheet 1 C2
Sheet 2 C2
Sheet 3 C2

Thanks!
--
Laurie