I am trying to get the following to work to calculate percent change:

=INDIRECT(("'"&$E$1&"'!" &$C$2& "42" - "'"&$E$1&"'!" &$D$2&
"42")/"'"&$E$1&"'!" &$D$2& "42")

whe $E$1 holds the sheet name(in same workbook) containing the data and
$C$2 and $D$2 hold the row references such that without the Indirect it would
read:

=('Data'!X43-'Data'!W43)/('Data'!W43)

I need the Indirect becuase I have 35 cases in which I need to do this
calculation and if all I have to do is change the row reference I am golden!

Any help is appreciated. Thanks!
--
javablood