=IMPORTRANGE("(IMPORTRANGE(“*MASTER SPREADSHEET URL*”, “*LINKS PAGE*! B1”))","*OTHER SPREADSHEET PAGE*!A1:Z500")
That formula has several issues, including:
=IMPORTRANGE([1: "(] [2:IMPORTRANGE(“\*MASTER SPREADSHEET URL\*”,] “*LINKS PAGE*! B1”)[1: )"],"OTHER SPREADSHEET PAGE!A1:Z500")
[1]no quotes or parentheses required here[2]if the 'LINKS PAGE' sheet is in the same spreadsheet file where this formula resides, you should not useimportrange()to read the value; use a simple range reference instead
To import from the spreadsheet identified in cell B1 on the 'LINKS PAGE' sheet in your master spreadsheet, use this:
=importrange('LINKS PAGE'!B1, "OTHER SPREADSHEET PAGE!A1:Z500")