I have about 200 google spreadsheets. Each of these google spreadsheet has multiple sheets. I need to gather the data of one of the sheet in all the 200 google sheets to one combine sheets. it is like the data from a specific sheet, specific range need to be combined. I need them to be vertically added to the resulting combined sheet. I have tried google add on "combine sheets", unfortunately the final product which I am getting is not what I require. from the add on combine sheets, it is adding the data from multiple sheets one below the other horizontally in rows, however, I need them to be added vertically to columns. is it possible to combine them vertically and how can I achieve this?
importRange
but even though a limitation on the number of linked spreadsheets has been lifted, users are reported inconsistent results. Also 200 spreadsheets might have an effect on the calculation time. Personally, I think I would go for a script ; you can choose whether/when to update the data (or create an onOpen trigger).