Good Morning,

I am trying to update an external reference by formula. The workbook I'm linking to has a separate worksheet for each day of the month. I'll demonstrate by example. Currently I have a worksheet called October and each day has its own worksheet, currently linking the 9th. I have several of these formulas from the same worksheet and want to be able to link to another reference point to update to the current date all at once. The bottom formula is what I envision it looking like, but obviously doesn't work, where I2 could be updated with 9th, 10th, etc.

='[October 2013.xls]9th'!$I$72

='[October 2013.xls]=I2'!$I$72