Google Sheets/Excel Boffins!

I want to vlookup a result in a named array based on text in another cell.
For example.
A1 text is Cats (This is also the table array name)
B1 text is Dogs (This is also the table array name)
C1 text is Rats (This is also the table array name)

The formula in A2 needs to look up the data in the Cats table on another tab and give a result
The formula in B2 needs to look up the data in the Dogs table on another tab and give a result

I can do this by changing the formula in A2,B2 etc but I want it to do it automatically based on what is in A1. There could be 10's of arrays (Animals!!)

Any ideas?