I am using the following formula to return values from other worksheets. Unfortunately, I am only getting the first Match Values for each record.

=IFERROR(INDEX(INDIRECT("'"&Y$1&"'!$X$1:$X$1000"),MATCH($B58&"*",(INDIRECT("'"&Y$1&"'!$R$1:$R$1000")),0)),"")

Can anyone tell me if it is possible to capture the Sum Value of all Record Matches please.