Formula / Cell Reference Help!

I have a cell, B23, that is the reference cell involved in many formulas (a blank cell waiting for an input value to be placed in it and it produces an answer in cell B38). I have several cells in ot...