Trying to VLOOKUP multiple tabs to return

Im trying to VLOOKUP multiple tabs 8 in total im using IF followed by ISNA then VLOOKUP as follows:

=IF(ISNA(Vlookup(C3,'1.01'!A3:'Mats assemblies Lookup'!,2,FALSE)),IF((ISNA(VLOOKUP(C3,'1.02'!A3:B199,2,FALSE)),VLOOKUP(C3,'1.03'!A3:B105,2,0),VLOOKUP(C3,'1.04'!A3:B128,2,FALSE)),IF(ISNA(VLOOKUP(C3,'1.05'!A3:B176,2,FALSE)),VLOOKUP(C3,'1.06'!A3:B1059,2,0),VLOOKUP(C3,'1.07'!A3:B282,2,FALSE))),ISNA(VLOOKUP(C3,'1.08'!A3:B59,2,FALSE)

I Keep getting an error can any one help? Also please be advised there are more than one work sheet

I have also tried:

=VLOOKUP(A2,INDIRECT("'"&INDEX(Sheetlist,MATCH(1,--(COUNTIF(INDIRECT("'"&Sheetlist&"'!$A$2:$B$5"),A2)>0),0))&"'!$A$2:$B$5"),2,FALSE)

=IFERROR(VLOOKUP($A2,Sheet1!$A$2:$B$5,2,FALSE),IFERROR(VLOOKUP($A2,Sheet2!$A$2:$B$5,2,FALSE),VLOOKUP($A2,Sheet3!$A$2:$B$5,2,FALSE)))

which seem to have trouble with more than 3 work sheets.