Pulling information from multiple tables into one source

Aizande

Currently I have a master table containing pointers to different tables based on date.
I need to pull all of this information into one large dataTable processed on the server side.
I was hoping for the data table to look like this :
`````
2014-12-31 John Smith 220 Hartford -> Pulled from table 1
2014-12-31 Jane Smith 221 Hartford -> Pulled from table 1
2015-1-31 Juan Smith 223 Hartford -> Pulled from table 2
2015-1-31 Peter Smith 224 Hartford -> Pulled from table 2
2015-2-31 Peter Smith 224 Hartford -> Pulled from table 3
etc

In Java the code looked liked this

rsDate = stDate.executeQuery("select & from " + tableName")
while(rsDate.next()){
rs= st.executeQuery("select * from "+ rsDate.getString("metadata_Table"));
//metadata_table contains the 'current' date it is cycling on

Anyone have any ideas?