I have a a list of invoices created with Google Spreadsheet. Now I would like to retrieve the data inside of those invoices to create another spreadsheet called "All" that contains a row for each invoice.
Name Phone Street John 677 Main Mary 897 Niceday
Is there any way to do that automatically instead of referencing cells one by one?
One more: imagine, I add a new invoice file, I would like that after addding it, the Name, Phone and Street inside it, were added automatically to the "All" file. Is possible?