Excel formula for Web Address

[EHP]

Hi

I have a cell within a spreadsheet, that references a different spreadsheet (see bottom for examples)
Is there a way to create a formula so that I don't have to either enter each address manually or copy & paste. I tend to find errors with these two methods. Due to security restrictions I cannot use Macros.

From the example below, I am using two spreadsheets, accessing different cells within different tabs.

Cell A1 : ='https://sharepoint.location.com/folder1/subfolder/Finance/[Filename.xlsx]Sheet1'!$D$7
Cell B1 : ='https://sharepoint.location.com/folder1/subfolder/Finance/[Filename.xlsx]Sheet1'!$D$9
Cell C1 : ='https://sharepoint.location.com/folder1/subfolder/Finance/[Filename.xlsx]Sheet2'!$J$107
Cell D1 : ='https://sharepoint.location.com/folder1/subfolder/Finance/[Filename.xlsx]Sheet2'!$A$88

Cell A2 : ='https://sharepoint.location.com/folder1/subfolder/Finance/[Another_Filename.xlsx]Sheet1'!$D$7
Cell B2 : ='https://sharepoint.location.com/folder1/subfolder/Finance/[Another_Filename.xlsx]Sheet1'!$D$9
Cell C2 : ='https://sharepoint.location.com/folder1/subfolder/Finance/[Another_Filename.xlsx]Sheet2'!$J$107
Cell D2 : ='https://sharepoint.location.com/folder1/subfolder/Finance/[Another_Filename.xlsx]Sheet2'!$A$88

Hopefully this makes sense.

EHP

 

[Special-K99]

I presume there are more cells to fill in that you havent mentioned?

There's no pattern to the cell references, so I doubt it.
They start off well, D7, D9...
so each cell reference would be Dn where n is 7+(column number - 1) * 2...
but then they jump to J107 and A88 so that formula wouldnt work.

You could create a list of the cell references and use INDEX() with a column number to pull out the correct reference, but this may not be feasible if you have a lot of cells