Dynamic sheet name in formula
<p><code>sheet1</code> and <code>sheet2</code> are structured the same way.</p>

<p>In <code>sheet3</code> I'm using the <code>sumproduct()</code> this way:</p>

<p><code>=SOMMEPROD((**sheet1**!$C$2:$C$2000=$A3)*(**sheet1**!$B$2:$B$2000=D$2)*(**sheet1**!$D$2:$D$2000=$B3)*(**sheet1**!$E$2:$E$2000=$C3)*(**sheet1**!$I$2:$I$2000="Ongoing"))
</code></p>

<p>Is there a way to replace the hardcoded <code>sheet1</code> in my formula above by referring to a cell which correspond to the name of the sheet?</p>