I have a workbook with 4 sheets in. "Total", "2007", "2008" and "2009".
On the "Total" sheet cell

B1 contains "2007" and
B3 contains "='2007'!E3"

I would like to have the formula in cell B3 dynamic in such a way that I
can change the cell B1 to "2008" and by that have the cell B3 show the
value in cell "='2007'!E3".

I have tried different types of "Indirect" by with no luck.

Please tell me how to code this.