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.
So in my example I have replaced the Year within your file name to a *. This will automatically open all of the files and stack them on top of each other. This will only work providing the sheet name is the same across those files.
If everything is structured the same way, you could use the directory tool with a dynamic input. If you have those files in the same folder, you can set up the directory tool to look for all files that meet a specified criteria in that folder.
Now that you have the full path for all the files that meet your criteria, we can feed that into a Dynamic Input tool to go out and pull all of the sheets with those specific names in those specific files (make sense). You need to initially set up the dynamic input tool the same as if you were setting up a regular input tool to go look for a file, and then configure like that above.
If your tables aren't structured the same there is a chance that this method will break, but give it a shot and lets see what comes back at us.
On the chance that they are structured differently @Joe_Mako has a bunch of stuff out there where he will create macros to solve similar issues.
Thank you for your input as its very helpful. For the most part, the sheets are structured the same -- data-wise, but there are nuances that seem to make Alteryx cranky. Nothing more than some comments. Let me work through your solution and see if it leads me in the right direction.