Hi everyone,

I have a workbook with a number of sheets. Each sheet contains links to other workbooks. Every month I have to update links manually.

For instance:
Old:
='Z:\COSTING\2012\08-AUGUST-12\[Executive Report - YTD AUG 2012.xls]Cement'!$C$13
New:
='Z:\COSTING\2012\09-SEPTEMBER-12\[Executive Report - YTD SEP 2012.xls]Cement'!$C$13

I was thinking to make the following parts of the link “08-AUGUST-12” and “- YTD AUG” treated as variables.

Thus, every month I will have to choose from a list the next month (e.g. September) and all the links will be updated automatically.

I tried this with the INDIRECT() function but I realized that when updating the links, all the related excel workbooks had to be opened.

Any ideas how to choose from a list the next month (e.g. September) and all the links will be updated automatically?

Thanks in advance for your help.