Corinna,
If your original formula was in B6 then for your task you should have
used:

=OFFSET(B6,-1,0)

The formula you used points to B5. Inserting a row below does not
affect B5. The moved cell still points to the original source.

HTH
Kostis Vezerides