Amend formula

[Excelski]

Hello,

I am using the following formula =SUMPRODUCT(SUMIFS(INDIRECT("'"&Table2&"'!"&"L5:L1049"),INDIRECT("'"&Table2&"'!"&"J5:J1049"),">="&$I$1,INDIRECT("'"&Table2&"'!"&"J5:J1049"),"<="&EOMONTH($I$1,0)))
Which returns the sum total of all my sheets within a date range.

How can it be amended to sum individual sheets using the sheet numbers contained in my list Table2

Thanks
Kevin

[Excelski]

I figured it out =SUMPRODUCT(SUMIFS(INDIRECT("'"&Table2[@Column1]&"'!"&"L5:L1049"),INDIRECT("'"&Table2[@Column1]&"'!"&"J5:J1049"),">="&$I$1,INDIRECT("'"&Table2[@Column1]&"'!"&"J5:J1049"),"<="&EOMONTH($I$1,0)))