Iferror, index & match

Hi I am new to this forum so apologies if I am not posting in the right way.
I am trying to setup an formula to look for an invoice number across 10 bank transaction sheets (different currencies) and return the amount paid.
The formula needs to search the first currency sheet e.g. gbp, then the next e.g usd etc etc and return the amount paid if it finds the invoice number.

The IFERROR works referring to 2 sheets but I am having trouble adding any more sheets to it. $A$3:$F$10 is the range on each bank sheet to search

=IFERROR(INDEX(usd!$A$3:$F$10,MATCH(B3,INDEX(usd!$A$3:$F$10,0,4),0),5),INDEX(eur!$A$3:$F$10,MATCH(B3,INDEX(eur!$A$3:$F$10,0,4),0),5))

I have tried adding ,IFERROR (obviously changing the sheet refs) and &IFERROR as well but it keeps saying error or too many arguments.

=IFERROR(INDEX(usd!$A$3:$F$10,MATCH(B3,INDEX(usd!$A$3:$F$10,0,4),0),5),INDEX(eur!$A$3:$F$10,MATCH(B3,INDEX(eur!$A$3:$F$10,0,4),0),5)),IFERROR(INDEX(aud!$A$3:$F$10,MATCH(B3,INDEX(aud!$A$3:$F$10,0,4),0),5),INDEX(nzd!$A$3:$F$10,MATCH(B3,INDEX(nzd!$A$3:$F$10,0,4),0),5))

This is probably really simple but any help is much appreciated.

Many thanks

Hi many thanks that does make it simpler and have amended but I still can't add other sheets to the formula as IFERROR only has 2 arguments and I can't seem to add another IFERROR, not sure what I am doing wrong

=IFERROR(INDEX(usd!$D$3:$D$10,MATCH(B3,usd!$E$3:$E$10,0)),INDEX(eur!$E$3:$E$10,MATCH(B3,eur!$D$3:$D$10,0)))&IFERROR(INDEX(gbp!$D$3:$D$10,MATCH(B3,gbp!$E$3:$E$10,0)),INDEX(aud!$E$3:$E$10,MATCH(B3,aud!$D$3:$D$10,0)))

Many thanks

Sorry error in ranges in previous posted formula, correct one below - nevertheless still not working so any help, many thanks
I am entering as an array as well in case that is the problem.

IFERROR(INDEX(usd!$D$3:$D$10,MATCH(B3,usd!$E$3:$E$10,0)),INDEX(eur!$d$3:$d$10,MATCH(B3,eur!$e$3:$e$10,0)))&IFERROR(INDEX(gbp!$D$3:$D$10,MATCH(B3,gbp!$E$3:$E$10,0)),INDEX(aud!$d$3:$d$10,MATCH(B3,aud!$e$3:$e$10,0)))

Thanks

Hi Glenn

Please see attached

Many thanks
Harriet

Hi Glenn

Made spreadsheet a bit clearer, see attached
Many thanks

Hi Glenn unfortunately I couldn't open your uploaded spreadsheet but I have used the formula that Martin kindly provided and it has worked - thank you so much to both of you for your help.