Help Trying to lookup data across multple sheets with variable locations for data.

trying to deliver the result From Table 1:A3:A1000 in Cell Table13 A2:A1000 which is the matched result from the text found in Table1 A3:1000 but only if Table13 B2:B1000 matches the text found in table1 B3:B1000

I have tried the below;

Please Login or Register  to view this content.

but cant seem to get this working at all, let alone working for data in all tables.

I also have the same setup found in the following tables: Table13, Table134, Table135, Table136, Table138, Table139, Table1310, Table1311, Table1312, Table1313, Table131314, Table131315

the only downside is data can be variable, i.e not in the same cell locations. I.E. on table13 the data could be in Cell A20 yet on table 134 the same text data could be in Cell A10, so the complexity of trying to lookup from the data found in B coloumns yet cross reference with the Table 1 or master list)

I have attached a copy of sheet for reference.

I get a spill error when I input the same code?