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.
Thanks all. @messi007 I tried that but if it is before the dynamic input it seems to just change the list of sheet names I've inputted just before the dynamic input, and @gabrielvilella your suggestion inexplicably doesn't work..
@csmith11 I'll try the macro, thanks a lot for your help
@chickenlicken great! Let me know how it goes and whether you have any questions. If it ends up working out for you, please consider marking as the solution to help other Alteryx Users identify the solutions faster.