Is it possible to connect sheets from multiple sources? For example, Google sheets, Excel? Do I need to convert them on my own first before I try to connect them?
You can actually add multiple sources to your connection @Tyla.
You do it by either selecting an entire folder, or manually selecting the files.
The one thing you should consider is formatting. They all have to follow the same template to be “consolidatable”.
As long as they have the same structure, you should be fine.
Yes it all worked!!