Reference cell value in a different workbook where the sheet name is defined by a cell

[kell22]

Hi,

I have a total of 6 workbooks that each have 12 sheets January to December, 5 of the workbooks hold data and the 6th is to collate data from all the other workbooks!

I am trying to reference a cell in a workbook where the sheet name is defined by a cell value. I can directly reference it by using the formula:

='[Dept 1.xlsx]January'!N32

So the workbook with the formula in is called "Overview", in cell m11 I can use the formula to look into the second workbook called "Dept 1" and on the sheet called "January" in cell N32 is the data I require. which works!

What I would like to do is modify the formula so that the sheet name in the "Dept 1" workbook is defined by cell "I5" in the "Overview" workbook. this is because there are 366 cells to reference in January. I would like to be able to copy the page, change the value in I5 (overview) to February so it pulls up the data from Dept 1 February workbook on the overview workbook sheet February.

I have looked at indirectly referencing the cells but not had much luck, can anyone suggest another way to try?

I have attached 2 sample workbooks if that helps.

Thanks in advance