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.
For some reason I couldn't find this solution when searching import sheet names and so I came up with my own solution, not as nice as the macro or other solutions but it works. Using the input tool and importing the list of sheet names, then the dynamic input tool to read in the sheets and setting the template input to add the Full File Path to the file output. From there a formula tool to just pull the sheet name from the end of the full file path and Bob's your uncle.