Yes, there are several ways in which you can create an automated and dynamic template.
I am a professional Excel expert.
MS Excel is the area of my expertise. I posses years of expertise with years of experience in designing high quality, automated and dynamic Excel based templates & dashboard including Budgeting, Forecasting, Analysis, Reporting and Variables Optimization. Well-versed and significant knowledge of utilization of advance level tools of Excel including VB and Macro.