I have a need to referencing another workbook, that will
not be open, where the name of this workbook will change
once every month or so. In the past I have always manual
changed all the cell formulas that references to this
workbook. But the number of them is increasing. Is their
any way I can reference a workbook that changes names
often?

I have looked into the address function hoping that I
would only have to change 1 cell but I could not get it
to work, I have tried to create a custom function where I
pass VBA a path/file/cell and get the cell value back but
that did not work either.