This what I am using in all of the cells. But if the IRR sheet changes (starts on row 3 instead of 43), none of the formulas work.

='IRR'!E232

Just like the formulas you have suggested, if the IRR sheet changes, the formulas don't work.

Am I asking Excel to do something that it won't do?