Consolidate or Similar, Only with Formula Reference?

[Scotster]

I have a combined worksheet that sums the values of all sheets within the tabs "Start" and "End". This means that I can duplicate this workbook and change the tab references within the Start & End tabs for different areas and to a different quantity of references, keeping the same format.

I was wondering if it would be possible to do away with all the sheets and instead use consolidate, or something similar. The only issue so far that I've found is that the consolidate needs ran each time the reference values have an update. I was hoping that instead of consolidating the values/calculation, it could instead keep the formulae.

There are over 5000 cell references through over 100 workbooks, so it would be a fantastic achievement to get it to work. All layouts, sheet names & references are exactly the same. The only change is the location/name of each of the files.

Workbook1
Workbook2
Workbook3

The formula I would like to have throughout the range J6:LT80 is as follows:

=[Workbook1.xlsx]Combined!J6+[Workbook2.xlsx]Combined!J6+[Workbook3.xlsx]Combined!J6

or a SUM variant. With obviously the cell reference changed.

The reason I don't have this currently is the number of workbook references changes from workbook to workbook, so a simple copy and paste partial of the formula wouldn't work for me. As it stands currently I allow users to set the file reference of each tab within the Start & End tab, so that the references are easily updated by the users.

Is such a thing possible, or am I better sticking with what I have now?