I am creating a summary worksheet that needs to access several workbooks and I am wondering if there is a quick way to do this without having to create a formula going into each one. I have several workbooks, lets say one for each province and in each workbook I have several worksheets, which are identical from workbook to workbook. I want to make a master workbook that will summ across the workbooks.

Something similiar to adding the same cell across several worksheets (i.e =SUM(BC:QUE!B15)) which adds the cell B15 across all the worksheets, but for difefrent workbooks.

Any suggestions?