How do I use a name when the name is written in a cell?

Hi!

I have many tables named TableA, TableB, TableC and so on.
I need to get one value from each of these tables and put it in its own table.
So I was thinking of using the Index function like this:
=INDEX(TableA,3,4)

But since I am going to do this with many Tables it would have been great if it was possible to have two columns and do something like this:

Table	Value
A	=INDEX("Table" & A2,3,4
B	=INDEX("Table" & A3,3,4)
C	=INDEX("Table" & A4,3,4)
D	=INDEX("Table" & A5,3,4)
E	=INDEX("Table" & A6,3,4)

Unfortunately Excel doesn't understand what I mean by "Table" & A2 and so on..
Is there some way to do this?

Try

=INDEX(INDIRECT("Table"&A2),3,4)

AAH! Perfect! Thanks!

You're welcome.