Cross worksheet references cannot be easily changed
 

I have a 21 worksheet, workbook. The first sheet is 'info' and contains
common information used in the other 20 sheets. If I try to change a
reference (for instance: change an '=info!$A$1' to let's say '=info!$A$5')
what winds up in the cell is the literal '=info!$A$5', not the new common
value. The way I am doing it is to create a new row, make it '=info!$A$5'
(the new common value is now in the created row) and move it to replace the
original cell.
Am I doing something wrong?