Good afternoon

I have a worksheet with several cells which are referenced from another, closed workbook.

An example of once such cell (D7) is ='C:\Users\leonj_000\Documents\Dissertation - INSM025\FOI\FOI Responses\6\[6.xlsx](1) Project Management'!$C$3

What I would like to do is have a similar formula on the following row (D8) which would reference 'C:\Users\leonj_000\Documents\Dissertation - INSM025\FOI\FOI Responses\7\[7.xlsx](1) Project Management'!$C$3

I could move each of the files into a single folder if it is easier to just increment the filename.

I have looked at Indirect and other things but cant figure it out.

Thanks

Leon