ok heres my problem, im trying to link 2 cells together from 2 different workbooks, easy peasy only the source cell is a part of a template (we use it for timesheets) so what i want to do is get excel to pull out data from the same cell from the correct file. for example if the destination cell is for january week 1 I want excel to look in file =Excel.Sheet.12|'C:\Users\samuel.brierley\Documents\january_week1.xlsx'!'!Sheet1!R7C2'. but the cell below to look in =Excel.Sheet.12|'C:\Users\samuel.brierley\Documents\january_week2.xlsx'!'!Sheet1!R7C2'.

basically my plan was to use concatenate to build this link as most of the file path is the same but when i do this all i get is the link in text form?

I realise I can manually put in all these links but every time We take on new staff I will have to add more links and the all this increases chances of error.

any help if much appreciated