Tableau has union functionality for SQL databases (eg Microsoft SQL, MySQL, etc). You will need to create a new connection and perform the unions.
The next step is to Replace Data Sources. If you have used fields that do not exist, such as changing names) you can remap these by replacing field references.
Let me know if this helps.