vlookup entire workbook

[BobbyBrownPants]

Hi everyone and thanks in advance

I have a workbook with 382 sheets. 381 of the sheets are all the same format

I need to VLOOKUP from A2 in the 1st sheet to find that value in cells K7:L56 of all the other 381 sheets returning column L

I've used
REPLACE(GET.WORKBOOK(1),1,FIND("]",GET.WORKBOOK(1)),"")
to create a list of the sheet names and created a List Name of these called MySheets

I've tried using this formula
VLOOKUP(A2,INDIRECT("'"&INDEX(MySheets,MATCH(1,--(COUNTIF(INDIRECT("'"&MySheets&"'!$K$7:$L$56"),A2)>0),0))&"'!$K$7:$L$56"),2,FALSE)
and completed it using Ctrl + Shift +Enter but it hasn't worked

Can anyone help please?

Thanks again
Bobby