How can I auto-generate a report from a template?



I have a template that I use for new clients, and I'd like a report that generates for each new template I create - specific to that template.

What I'd like it to look like is:

  1. A new copy of Sheet Template A is generated in Workspace X - we'll call it Sheet X
  2. A new report is automatically generated from Report Template A in the workspace that Sheet X was created in - this new report is linked to Sheet X - we'll call it Sheet X Report

Is this possible?

Thank you,