I'll use a simple example for my problem:

In cell C3 I have the formula =$A$3-$B$3. The problem is I need to be able to cut cell B3 and post it elsewhere, or delete cell B3 and shift the cells below it up. If I cut cell B3 and paste it in, say, D3, the formula in cell C3 changes to =$A$3-$D$3. I could copy cell B3 and paste it in D3 and then delete cell B3 and shift the cells below it up but then I get a reference error in cell C3. How do I or is there even a way to make the formula in cell C3 remain the same no matter what I do to the cells it refers to?