Pulling Data from a certain Cell Block

[FireOracle]

I was trying to pull data from a Data Input sheet and place it on several other sheets. When I try to use the ='Input Data'!A1 , when i move the data on the input page it pulls from the new loctions. Is there anyway I can pull data from a specific cell block and no matter wether it is deleted or moved it will always pull info from that cell block? I have tried the $A$1 , it only works if you are moving the cell you typed it in, not the cell you are pulling data from. Thanks! Please respond.

 

[pgc01]

Hi FireOracle
Welcome to the board

Please try

=INDIRECT("'Input Data'!A1")

Hope this helps
PGC