Dynamic Index Match Match with Indirect

Hi

I'm trying to pull data from many sheets to a sheet called "Catalog", but I'm not getting the results I want.

I'm currently using this:

=INDEX(INDIRECT("'"&Sheet_Table[Sheet_List]&"'!A1:B7"),MATCH(A2,INDIRECT("'"&Sheet_Table[Sheet_List]&"'!A1:A7"),0),MATCH("Price",INDIRECT("'"&Sheet_Table[Sheet_List]&"'!A1:B1"),0))

I need it to pull the price of the items listed in "Catalog" from the sheet where the item is located.

Thank you!

=IFNA(VLOOKUP(A2,INDIRECT("'"&$G$2&"'!"&"$a$2:$b$7"),2,FALSE),IFNA(VLOOKUP(A2,INDIRECT("'"&$G$3&"'!"&"$a$2:$b$7"),2,FALSE),IFNA(VLOOKUP(A2,INDIRECT("'"&$G$4&"'!"&"$a$2:$b$7"),2,FALSE),"")))

this may possibly help you have 3 sheets, for every additional sheet we might have add another condition.