Hi Yes I'm looking for this function as well

I am looking for cells $A$1, but from many different sheets

So I want it to be

Sheet1!$A$1
Sheet2!$A$1
Sheet3!$A$1
Sheet4!$A$1
..etc etc

the fill handle can't seem to figure out that it is the sheet numbers that are changing and nothing else