lookup a cell on another woksheet by using the tab name

[Guest]

I have 95 worksheets. Each one has been named.

I have a list of these same names on my summary sheet.

I want to lookup a cell on the worksheet that matches my summary cell details.

Thus my summary list has Paul Peter John Adam

I have worksheets for Paul Peter john Adam

I want my summary sheet cell d3 to show the value of cell r88 on worksheet
Adam under the Adam column of my summary sheet

 

[Dave Peterson]

If adam is in A4, you could use:

=indirect("'" & a4 & "'!r88")

Debra Dalgleish has some notes about =indirect():
http://contextures.com/xlFunctions05.html

 

[Guest]

tHANK yOU VERRY VERY MUCH. I HAVE BEEN LOOKING FOR THAT FOR ABOUT 5 YEARS.

THANK YOU VERY MUCH DAVE