chatGPT imo is a bit more polished but it's slow AF whereas Bard is fast but still isn't quite there yet.
btw I copy pasted your question here is what I got:
=ARRAYFORMULA(
VLOOKUP(
A2,
[{Sheet1!A2:B10, Sheet2!A2:B10, Sheet3!A2:B10, Sheet4!A2:B10, Sheet5!A2:B10},
2,
FALSE
)...