There are third party tools and few provided by tableau corporation to migrate the content like tableau migrate tool but you need to automate the stuff in your case by combining programming with the use of these tools.
Hope it helps.
Thanks, Bharat, but I am moreover interested in defining the approach/process.
The reason behind this discussion is to understand how we can set a process based on the requirement of mine stated in question but not how to do it.
Do you anything in mind on how the approach/process should be when we have to define the environment for Dev/QA/Prod etc.
To define a process u can
have a python or java or microsoft .Net program that is tightly integrated with tableau migrate tool and reads the workbook from a folder and changes the source automatically and moves the content from one environment to another.
but There will be manual intervention needed in the overall to check and test the data.