Drop Down to Access Differnt SharePoint Workbooks

[Tidr0001]

I have multiple monthly reports on a SharePoint website with sales data on the "Summary" Tab.

I am using a Data Validation drop down list to ID the months I would like to pull in.

	November 2013	December 2013	January 2014
Sales	XX	XX	XX
Inventory	YY	YY	YY

<tbody>
</tbody>

As I change the date in B1 or C1 or D1, I would like to pull the new data in from the corresponding sheet on SharePoint.
I have a reference sheet in the workbook that provides the URL Link for every report on SharePoint.
For Example:

	URL
November 2013	http://test.com/dpc/IM Toolkit/Archive/ Results Nov.xlsm
December 2013	http://test.com/dpc/IM Toolkit/Archive/ Results Dec.xlsm

<tbody>
</tbody>

Formula below works but is static:
= SUM('http://test.com/dpc/IM Toolkit/Archive/[Results Nov.xlsm]Summary'!Y$2:Y$25000)

Thinking something like:
= SUM(CONCATENATE(“'”,(Index(Ref Sheet!A1:B10,MATCH(B1,Ref Sheet!A1:A10,0),2),”Summary'!Y$2:Y$25000”)