I have sent out a large number of copies of a 'questionnaire' style workbook,
which are being returned to me as separate files. In order to analyse and
collate the large amount of numerical data, I have developed a 'summary'
sheet that draws information out of the various worksheets within each
workbook. I had hoped to copy one 'summary' worksheet into each of the
returned workbooks and then copy the summary sheets into a 'master' workbook.

I know it is possible to create absolute cell references using the $ sign,
but need what can best be described as an 'absolute sheet reference' to stop
external references appearing when I copy the 'summary' worksheet to the
different workbooks.

Does anyone have any suggestions please?

Many thanks
Richard