Why might a formula reference error occur after moving a worksheet?

When you move a worksheet, all relative cell references within formulas are adjusted automatically. However, if you've used absolute references ($A$1) or mixed references (A$1 or $A1), the formula might still point to the original location, leading to a '#REF!' error if that cell is no longer in its original position.