INDEX MATCH across multiple workbooks and worksheet including INDIRECT functions

I have been trying in vain to create a dashboard based on numbers from other published monthly Excel leaderboards for our team.
I don't have access to the raw data from which the leaderboards are derived, but I can see all of the rendered and interpreted data as it relates to our team's performance metrics.
So far, I have been attempting to use the below formula, but am getting a "There's a problem with this formula" error that I am still unable to resolve:

=INDEX(" ' http://intranetlocation/[ " & $C4 & "_" & D$4 "_LEADERBOARD.xlsx]" & D$2 & " ' !$B$5:$V$32",
MATCH("OUR TEAM"," ' http://intranetlocation/[ " & $C4 & "_" & D$4 "_LEADERBOARD.xlsx] " & D$2 & " ' !$B$5:$B$32" ,0),
MATCH(E$3," ' http://intranetlocation/[ " & $C4 & "_" & D$4 "_LEADERBOARD.xlsx] " & D$2 & " ' !$B$5:$V$5" ,0))

where

C column = reference year of leaderboard workbook title
D column = reference month of leaderboard workbook title
row 2 = helper line for tab name(s) in outside workbook(s)
row 3 = column with desired data

The bold section is where Excel is highlighting my error.

What am I missing in this syntax?

Is this too complicated with outside book and tab name references to employ for a single formula??