Formula for linking worksheet needs modification for it to work

[sleek12]

I am unable to discern where i am going wrong !
Any help given is appreciated,I started with Name manager
Sourcedatasheet==INDEX(REPLACE(GET.WORKBOOK(1),1,FIND("]",GET.WORKBOOK(1)),""),N(IF(1,ROW(INDIRECT("4:"&COUNTA(REPLACE(GET.WORKBOOK(1),1,FIND("]",GET.WORKBOOK(1)),"")))))))&T(NOW())

There is a dropdown list of names here--->(List worksheet)

	Sheet is called Query
S/no	Sheet name month	REF BRANCH <tbody> </tbody>	Trans Date <tbody> </tbody>
=IF(B4="","",MAX(A$3:A3)+1)	=IFERROR(INDEX(List!C:C,MATCH(1,INDEX(--(ROW(A1)<=SUMIF(OFFSET(List!D$1,,,ROW(List!$1:$12)),"<>")),))),"")	=IF(OR($B4="",C$3=""),"",IFERROR(INDEX(INDIRECT($B4&"!A3:S100"),AGGREGATE(15,6,ROW($A3:$A102)-ROW($A2)/(INDIRECT($B4&"!C3:C100")=$B$2),COUNTIF($B$4:$B4,$B4)),COLUMNS($A:A)),""))

<tbody>
</tbody>

List worksheet

	Details	To drag down below formula
	DOUGLAS OMBATI AND CO ADVOCATE2014/07/070/001016 KAN 615W MAKINI AUCTIONEERS AGENCIES 2015/20/070/00050 KBR 066JA.G RIUNGU AND CO ADVOCATES 2015/01/080/2322 KBB 872GA.M MBINDYO AND CO ADVOCATES-2014/01/070/000305 KAQ 417UA.M TAILOR LTD-KISII ELECTRICITYA.M TAILOR LTD-KISII RENT APRIL - JUNE 2018ABISAI AND CO ADVOCATES-2016/75/080/001325 KAL 487QABRAHAM LINCOLN ONYANGO-2017/04/070/000297 KBL 780RACUMEN EQUITIES LTD-	=IFERROR(INDEX(SourceDataSheet,ROWS($1:1)),"") <tbody> </tbody>	=IF(C2="","",INDEX(COUNTIF(INDIRECT("'"&SourceDataSheet&"'!C3:C50"),Query!$B$2),ROWS($1:1)))

<tbody>
</tbody>