Inserting a cell reference into a Workbook Reference

[KurtyK]

Ok so I regularly update files with hundreds of cell refrences to this workbook and different cells. Each year we recreate it and just update the year (i.e. from 2013 to 2014 as shown below.

='C:\Users\Me\Example\Issues\TEST123\Auto\2013\Fix\[How to 2013.xlsx]Tab1'!$A$1

='C:\Users\Me\Example\Issues\TEST123\Auto\2014\Fix\[How to 2014.xlsx]Tab1'!$A$1

='C:\Users\Me\Example\Issues\TEST123\Auto\2015\Fix\[How to 2015.xlsx]Tab1'!$A$1

and so on.

Is there a way to just have one cell in my workbook that I enter the date and it will change the bolded items to the appropriate date. I need it to find the correct folder and file though so I'm stumped.

Any suggestions?

 

[mikerickson]

You could use Find and Replace to find 2013 and replace with 2014, etc.