Sheetgo connection can merge data from multiple files into one or more files and leave the data in the source files intact. While the concept is the same, the connection setup has changed slightly. So let’s see what’s new.
We have this great guideline: How to merge multiple spreadsheets into one
And then you can filter by condition or by the query. Please, check this article: How to use Sheetgo filters to transfer specific data?
Please, let me know if you have any questions :)