I have sheet1 where
I input a value in cell A1 =(say 2)
After some calculations done in another cells using A1 value
finally cell A10 is the output value of the calculation.

I have another sheet2 in the same workbook
In column D , i.e D1, D2, D3 I input 2, 3, 4

I want in column E the output value of A10 of sheet1 for the
corresponding input of D1 for A1 (of sheet1).

How can write a macro for this.

Else the only way left out is

I manually substitue the value of D1 (of sheet2) in A1 (of sheet1) and
then copy the output value of A10 (of sheet1) to E1 (of sheet2)

Can anyone help in this regard.

simha Rupa Das