Search through multiple workbooks and sheets

[books4cars]

I need to find the total amount in H7:H13 in multiple workbooks and within the 1st 5 sheets in each workbook. Is there a way to do this?

Thanks

 

[dispelthemyth]

whereever you want the total, write this formula

=SUM(Sheet1:Sheet5!H7:H13)


replace sheet 1 with the 1st sheet name and
sheet 5 with the last sheet name

 

[books4cars]

The total needs to include about 10 workbooks with 5 sheets, each with the same range. I have this for one workbook, is there a way to have it include the other workbooks in the same folder?
=SUM('[JER MNGRS WEEKLY 09-2011.xlsx]WEEK 1'!$H$7:$H$13,'[JER MNGRS WEEKLY 09-2011.xlsx]WEEK 2'!$H$7:$H$13,'[JER MNGRS WEEKLY 09-2011.xlsx]WEEK 3'!$H$7:$H$13,'[JER MNGRS WEEKLY 09-2011.xlsx]WEEK 4'!$H$7:$H$13,'[JER MNGRS WEEKLY 09-2011.xlsx]WEEK 5'!$H$7:$H$13)

Thx