I have a large sheet that consolidates information from about five other
sheets. These other sheets constantly get name changes, as we indicate
changes with a date change in the title.

Is there a way that I can input current file names in five cells in the
master sheet, then use these cells to direct external references. Changing
all the formulas in a complex sheet is not easy, nor is it much fun.

Any ideas will be welcome.

Craig