Hy I have a Excel File (a) and a cell into it that is equal to another cell in another file (b);

The of the (b) excel file is "2010 something";

Now The cell (c) is ='[2010 something.xls]test'!$K$224

What I want is to make a variable that mantains the year and will be stored into a cell

Then the cell (c) will change its reference based on the year; So in 2011 instead of looking for the 2010 something.xls will be looking for the 2011 something.xls

How to do it? thanks