Sum same Range across multiple sheets (sheets are named range)
<p>I have a named range where it dynamically select from the 1st available cell to the last available non-blank cell. And this cell contains the sheet name.</p>

<p>So my question is:</p>

<p>How do I go about summing this cell from the same cell using the named range sheet name?</p>

<p>For example, without the named range, I could do</p>

<pre><code>=SUM('Sheet1:Sheet100'!A1)
</code></pre>

<p>How can I use the named range i.e. Sheet1To100 in this case, to sum the sheet in the same cell.</p>

<p>Thanks!</p>