I have a document that currently references a different excel workbook. Each month I update this piece of MI and have to change the folder it references as it changes each month.

e.g. last month the cell might link to c:\work\January\MI.xls, whereas this month I would need to change the January to February.

Is there a way to get the path name to reference a cell that contains the month in question.

e.g. c:\work\$A$1\MI.xls where A1 contains the month.

There are team members that update the document in any given month so Im wanting to make it as automated as possible

Thanks