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