We need google scripts written in our google spreadsheet templates.
We have two sheets and each have multiple tabs.
We would like a button in sheet 1 that generates a copy of a template sheet 2 and also communicate adds data to certain cells in sheet 1.
There will also be approximately 7 more buttons that send specified data and instructions to cells in sheets 1 and 2.
A few of the buttons will generate generic emails to our account.
Examples of communication between sheets will be:
"Button 1" adds "n" to cell A8, add timestamp to cell B8,sends contents of cell C8 and D8 to cell G11 and H11 of "sheet 2" - "tab 2."
Detailed build instructions will be provided.
You must be familiar with google script writing.