I am using the below sumifs formula that references another file that has a large number of Tabs.
This Large Data File uses First/Last Tabs - all Data Tabs are in the same format. Excel 2010

To do this, I believe I need utilise the @Indirect Function, but I am struggling to incorporate into the below formula.

=SUMIFS('[LargeDataFile.xlsx]2014'!$H$7:$H$665,'[LargeDataFile.xlsx]2014'!$D$7:$D$665,$C5,'[LargeDataFile.xlsx]2014'!$B$7:$B$665,D$2)

Thank you - Any help appreciated