Excel INDIRECT function

How to use the text in one cell as a sheet reference for another:

INDIRECT("'"&B7&"'!$E$7")


Linkage:
Excel User Tip: Referencing a sheet indirectly