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?