I'd like to automate an import from data in one spreadsheet into a new tab on an existing spreadsheet.
The goal is to consolidate data from a standard form that is created on an ongoing basis into one master spreadsheet that contains the data from all these new spreadsheets across different tabs. The data will always be the same shape.
I'm wondering if Google Scripts is the best way to do this? I'd like to avoid using things like importrange() since this would require some manual input.
Any suggestions?
I haven't tried any solutions yet.
