Moving columns with formulas gives #REF!
 

I am trying to keep my formulas with the cells they are associated with even
if the column location is moved so that I don't get a #REF! error from the
other sheets which house the formula. I have tried Protect but I cannot add
any information into those cells unless I unProtect. Other people use this
worksheet for entries but I don't want them moving things around and messing
up the formlas on the other worksheets.
Any suggestions would be greatly appreciated.
--
Miss Kitty