I have the following formula that uses the ROW() command.
=HYPERLINK("["&M16&ROW()&O16&"]")
M16 cell value = PC_
The formula is held in cell A16, so the ROW() command report back the value 16
and 016 cell value = .xlsx
The resulting hyperlink = PC_16.xlsx (which loads the file PC_16.xlsx)

I am trying to use the same ROW() command in another formula but all I get is the #REF! error can anyone please tell me where I’m going wrong?
='Z:\Product Change\["&M16&ROW()&O16&"]Product Change Form '!$D$45
I’ve even tried a different variation of the same command
='Z:\Product Change\[PC_"ROW()&".xlsx]Product Change Form '!$D$45
I am trying to report back the text value of a cell D45 in the same file PC_16.xlsx. If I write the formula as below it works
='Z:\Product Change\[PC_16.xlsx]Product Change Form'!$D$45

The reason I am using the ROW() command is because I need to cut and paste the formula to many cells and I want the formula to increment up (the file that it is looking at) without me having to manually edit each formula
for example PC_16.xlsx – PC_17.xlsx – PC_18.xlsx and so on, and I was hoping to use the ROW() command to report back the row number so that I could link it to a file with the same number. Alternatively if anyone has any other suggestions to how I can achieve the same goal I would be very grateful. I’ve been stuck on this last hurdle for 4 days now and it’s preventing me from completing my project.