formula for adding between sheets dynamically..
like i have 5 sheets namely - 2000,2001,2002,2004,2005..
i want add the cell B2 from each sheet for which the formula would be
=SUM(2000:2005!B2)
But i want to add to provide the sheet names dynamically like ..
I have put the name of the sheets in cell A2 and cell A3 and the cell-address in cel A3.
= SUM( INDIRECT("'"&A2&":"&A3&"'!"&A4)).

Is this possible.?