And, I can't seem to get the formula correct. I am trying to give the user the option to choose a month which will then populate a cell with data from a file specific to that month. So in cells A1 they would choose any of the 12 months from a list.

Then, in cell B1, the link would update and show the data. The link is ='C:\2006\January 2006\[January Per Unit Forecast.xls]Per Unit Forecast'!C$3

Obviously, I want to set up the link in such a way that the 2 areas where it shows January instead pull in the value chosen in cell A1 so that it updates with data from the month of my choice.

Thanks