This should be viable via parameters as you suggest. Can you attach a packaged workbook (.twbx) illustrating the different date fields and structures? We do not need any confidential data, just the dates, field and table names. See Anonymize your Tableau Package Data for Sharing |Tableau Support Community if needed.
Thanks Bill, I used Data blending to link few of the worksheets. and there was a requirement change so it worked out in the end.