Dynamic sheet name doesn't work

[xsmurf]

Hi All,

I have the following code, and I am pretty sure it is correct.

=IFERROR(INDEX(INDIRECT("'" & $G$1 & "'!$B$4:$B$265"), SMALL(IF((INDEX(INDIRECT("'" & $G$1 & "'!$I$4:$PH$265"), 0, MATCH($B$3, INDIRECT("'" & $G$1 & "'!$I$3:$PH$3"), 0))<>"")*(INDEX(INDIRECT("'" & $G$1 & "'!$I$4:$PH$265"), 0, MATCH($B$3, INDIRECT("'" & $G$1 & "'!$I$3:$PH$3"), 0))<>"R")*(INDEX(INDIRECT("'" & $G$1 & "'!$I$4:$PH$265"), 0, MATCH($B$3, INDIRECT("'" & $G$1 & "'!$I$3:$PH$3"), 0))<>"C")*(INDEX(INDIRECT("'" & $G$1 & "'!$I$4:$PH$265"), 0, MATCH($B$3, INDIRECT("'" & $G$1 & "'!$I$3:$PH$3"), 0))<>"H")*(INDEX(INDIRECT("'" & $G$1 & "'!$I$4:$PH$265"), 0, MATCH($B$3, INDIRECT("'" & $G$1 & "'!$I$3:$PH$3"), 0))<>"F"), ROW(INDIRECT("'" & $G$1 & "'!$I$4:$PH$265"))-ROW(INDIRECT("'" & $G$1 & "'!$I$4")+1), ROW(1:1))), "")

Unfortunately excel does not accept the formula and says "something is wrong with the formula"
I can't see to figure out what the problem is.
Maybe it has to do that I use a reference to a cell to get the sheetname?

Cell G1 has the following code

="Vacations " &YEAR(B1)

Cell B2 has the following code

=TODAY()-WEEKDAY(TODAY(),2)+1

Hope some one can assist mey, thank you in advance.

 

[Fluff]

As you have 365 why not use the filter function

=LET(a,INDEX(INDIRECT("'" & $G$1 & "'!$I$4:$PH$265"), 0, MATCH($B$3, INDIRECT("'" & $G$1 & "'!$I$3:$PH$3"), 0)),FILTER(INDIRECT("'" & $G$1 & "'!$B$4:$B$265"), (a<>"")*(a<>"R")*(a<>"C")*(a<>"H")*(a<>"F"),""))

 

[xsmurf]

Sorry for the late response, but this worked even better.
Thank you @Fluff

 

[Fluff]

You're welcome & thanks for the feedback.