how to replace the number of a document that's contained in a document, with a number in the cell to

[brianaclark1967]

Hi all,

I have a formula on a sheet that pulls information from a cell in a seperate sheet.

I make many of these seperate sheets which are stored on my pc.

I'm hoping to find a way of replacing the number in the formula, to correspond with the ref. number in the adjacent cell.

I've attached a sample sheet to try and explain.

Regards,

Brian

 

[Hui]

It will be like:
=INDIRECT("'\\LSDL-SERVER\Company\Delivery Notes\[DELIVERY REF " & A4 & ".xlsx]cover sheet'!$A$"&row()+x)

ie: If you put this formula in cell H3 and want it to reference H5 on the other worksheet it will be
=INDIRECT("'\\LSDL-SERVER\Company\Delivery Notes\[DELIVERY REF " & A4 & ".xlsx]cover sheet'!$H$"&row()+2)

 

[brianaclark1967]

Hi Hui,

Thank you so much for coming back to me.

I think I've confused myself.

I've attached the sheet again showing where I'm confising myself.

Regards,

Brian