This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I've had to do something similar too. Depending on the version of Excel your files have been saved in, you may be able to get a list of the tab names, otherwise I had to write some code in R to list the tab names. Of course you won't have to do this if the tab names are static every time. You will need the 3 pipes after the filename to dynamically open the file, e.g. <filepath>\<filename>.xls|||<tabname>.
Because your schema's are different for each tab, I would recommend creating an iterative macro and dynamically opening the file and tab on each iteration otherwise you may get schema different error messages.
have you tried already to use 3 different Input Tool, one for each tab, configure as @spainn said but instead of the file name try to use an * e.g. <filepath>\*.xls|||<tabname> ( all the input files have to be in the same folder).
In this way, you should be able to load, for example, Tab 1 of all 30 files, then you can do the same for the other 2 tabs.
Then with a union tool, you can merge everything together.