I have the same abolute cell reference across several named worksheets in a
workbook. I wish to summarise this data in a new "summary sheet". Does anyone
know how to increment the worksheets in a formula, so that when I use the
"fill handle" in the summary sheet it will bring in the data from each of the
worksheets.

Many Thanks