A dashboard would be your best option here. There is way to get what you want, but it's more work than just creating the five sheets.
Thanks, Rody. Unfortunately, my workbook already has more than 40 tabs, and there are multiple visualizations for which I wish to make this process work. So making dashboards is not really an option.
Even more important is the fact that this is used in a template I am sharing with clients each month. So I do not want to make it too complicated in case clients want to modify it. So I am looking for an elegant way with a minimum of sheets to accomplish what seems like a straightforward formatting task.
If you could share your solution, that would be great.