Hello-I’m not sure if I’m misunderstanding the the process for selecting “source” data, but it appears that the only 2 choices are to
- individually select spreadsheets, and then individually select each desired tab within those spreadsheets
- Select a folder and then get the 1st tab of every spreadsheet within that folder
I want to be able to consolidate all the tabs within a single spreadsheet, but was hoping not to have to manually select every tab. Is there a way to do this?