How to unload data from 6 tables into one without losing links?

Question

Database

Reworking the old site, I noticed that all the texts are divided into 6 tables in the database with the same structure. Do you have any suggestions on how to combine them into one? Since I have already organized one table on the new site :)
On the new site, all links are identical to links on the old one, the difference is only in the identifier, so it becomes difficult to set up a redirect.

Answer 1

As an initial option, add another field to the table and (to begin with) put an index there - in which table the text was.