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.