Personally I would merge all 13 workbooks into one workbook, with month
named sheets.

--

HTH

Bob

"mns" wrote in message
...
Hi there.
I have excel documents named like January.xlsx, Feb...xlsx then to
December.xlsx.
And I have a huge file named Year.xlsx which has links from these month
files (all formulas are the same, sama cell numbers, same worksheet names
etc..).
What I would like to know is is there any way to choose the month name and
excel could update itself. for example:
='[January.xlsx]Workseet 1'!$G15

Lets say I will resever A1 for data cell and will make a dropdown list
there. When I select February I'd like excel to update all formulas from
Jan
to Feb. It sounds too hard but I'm sure there is a way to make it. any
ideas?