I would like to use a function to create a sumamry sheet from a number of
worksheets in a work book.

I would like to create a single worksheet with references to the same cell
(i.e A3) but on different worksheets throughout the book.

Therefore rather than keepng the worksheet absolute when autofilling, I
would like to keep the cell range absolute (easy enough by using $) and
instruct autofill to pickup a different worksheet for each cell it fills
accross.