Using cell reference in a link to workbook

[Lewis93]

Hi Excel Hero's,

I am using Windows 7 and Excel 2007.


I have a list of a couple thousand reports e.g. 123456, 478096, 756842 all in differnt rows in Column A in a summary sheet.

I am trying to link a cell from the summary sheet to a cell within each report. This is fine when done manually and creates this link in the cell.

C:\\22. Visit Reports 2014\["123456".xlsm]KPI'!$AX$31

Is it at all possible to replace the report number shown in quotations above to a a cell reference e.g. A150?

Thanks

Lewis K