How To Search Multiple Table Which Table Name Is Store In Another Table And Join The Result Together?

I have one control table to store all related table name

 Table ID                   TableName

     1                           TableA

     2                           TableB

 

In Table A:

RecordID                Value

     1                         1

     2                         2

     3                         3

 

In Table B:

RecordID             Value

    1                         1

    2                         2

    3                         3

 How can I get the result by select the Table list first and then combine the data in table A and table B?

 

Thank you!