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