Autofill with sheet reference

[Legacy 473675]

So I want this formula to do exactly what it does, only that instead of manually typing in the sheet name for every cell I would like it to refer to the sheet name in A2. So I would be able to drag it down with autofill. Could anyone help me with this?

 

[Norie]

Try INDIRECT.

=SUM(INDIRECT("'" & A2 & "'!D:D")) - SUM(INDIRECT("'" & A2 & "'!D1:D2"))