How about something like this

=INDIRECT("'"&A1&"'!$B$11")

Where A1 contains the worksheet name. They'll need to match exactly for
this to work.
--
HTH,
Barb Reinhardt



"Fanny" wrote:

Dear Helpers,

I have 60 worksheets of a group salesmen. I have successfully listed all
the worksheet names in a summary work sheet. If I need summarise their
sales figures, I need to go to each worksheet to link the specific cell to
the summary. For example,

Worksheet Name Sales figures
Peter (=Peter!$B$11)
Mary (=Mary!$B$11)

Is it possible to make formulaes by combining the name and cell to link to
the specific cells of each worksheet instead of going to each worksheet?

Thanks in advance

Fanny