Hello,

I am trying to write a series of formulas that will be pulling from different workbooks. The thing that determines which workbook to call from is by month and year. I was wondering if there was a way to make a formula that is calling from a different workbook change name depending on a cell's reference. Say I have "Market Share August 2014" and I want to call from "Market Share October 2014", is there a way to have an input cell that would change August to October? I tried &Q2 (where my input cell will be) but it didn't work.

Thanks.