I have Spreadsheet 1 where multiple cells are functions of cells in a different spreadsheet. For Example =SUM('[Other Spreadsheet.xlsx]Tab'!$I$131:$K$131)
I would like to have a cell where I name the Other Spreadsheet and if I change this name to Other Spreadsheet Number 2, then all the formulas on Spreadsheet 1 will start referring to a different spreadsheet called Other Spreasheet Number 2.
All those spreadsheets would be on sharepoint and accessible to other people in my company.
The INDIRECT function can do that when all files being referenced are open. Whether that works on Sharepoint I have no idea. But read up on INDIRECT here and try it out. Be forewarned that if you use it a LOT in your spreadsheet, INDIRECT can slow things down considerably.