Use Indirect, eg.:
=INDIRECT("B5")
and to avoid loads of formulae with Indirect in, you could put formulae such as the above in only a few cells and have the more complex formulae refer to those cells insteasd of the ones being drag'n'dropped to