Hi Thomas

what are your sheet names? (an example of 2 or 3 will do)

Cheers
JulieD

"Thomas" wrote in message
...
I have an ablsolute cell reference (for example Cell A1) on 10 different
sheets in my workbook.

I want to know if theres a formula I can copy down that will pull cell A1
from each of the sheets. Is there a way to do this without manually
clicking
the cell on each sheet?