Insert Records from Multiple tables using Single Query

I have multiple detail table wherein object specific records are stored. The structure of all the detail tables are similar. 

Now, we are optimizing our database and in the process of the same, we need to create a single table, which will store the records of all these multiple tables, with one additional field, representing the object which it is associated with.

I want to make this transition as smooth as possible. I am in search of some sample query which i can use to populate all the data from all these multiple tables into one new table with one additional field in the new table.

Please help.