I would like to be able to create a new sheet from a template autofilling some details. Is this possible?
I don’t think this is possible. What is your use case for this?
I want to generate reports from a master list
Can you share with us more about your data flow? What do you have in your inputs, what calculations do you use and what do you want to see in your report?