Spreadsheet name containing specific value

[gtd526]

Hello,
Im using an array formula to get the average for a specific symbol (F:F) on all/single spreadsheet(s) listed in formula, and it works.
How can I use the array (or any other) formula to get the spreadsheet name containing the specific symbol?
Thank you

The Whole Enchilada.xlsm
	E	F	G
35	TECL	30.11%	TEST
36	FNGG	-3.54%
37	WBREOX	2.27%
38	FBGKX	2.94%
39	SVSPX	0.00%
40	0	No Data
41	0	No Data
42	0	No Data
Capital Gains Tax

Cell Formulas
Range	Formula
F35:F42	F35	=IFERROR(AVERAGE(IFERROR(AVERAGEIFS(INDIRECT("'"&{"Schwab","Roth IRA","AMTD","401k"}&"'!L9:L15"),INDIRECT("'"&{"Schwab","Roth IRA","AMTD","401k"}&"'!A9:A15"),E35),"")),"No Data")
Press CTRL+SHIFT+ENTER to enter array formulas.