I dont this this possible in Tableau as per my understanding your requirements.
You might need third part tools to automatic your reports in the robust ways.
Thank you for the reply. I had in fact seen that post before and linked in my original posting. However, as I indicated, that relies on an third party software which I do not believe we will be able to use on our client's systems.
Any other alternatives?
In the same blog, there is one more alternative using scripts, I never work on this but it might be interesting using Power Shell and tabcmd.