Hello,

I'm trying to pull data from a document (2014 Source Data) into a new workbook. I'm would like to have my INDEX/MATCH function be dependant on a cell value in this new workbook. Below is how the existing formula is setup.

={(INDEX('[2014 Source Data.xls]January 2014'!$C$2:$C$678,MATCH(1,('[2014 Source Data.xls]January 2014'!$B$2:$B$678=$C3)*('[2014 Source Data.xls]January 2014'!$H$2:$H$678=$D3&" "&$F$2),FALSE)))}

I want the sheet name in the formula to change based on what I choose from a drop down (different months). I've tried using INDIRECT but can't seem to figure it out. The source document will always be the same, it's just the sheet name that changes.

Any help is greatly appreciated.