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.
Hi there! I'm trying to combine 10+ files currently saved in a shared folder. Unfortunately, the schema changes across the files (new fields are added or removed month after month). Each file in the folder contain 2 worksheets (1) Vacancy (2) Pivot. I'm trying to combine all the files to create a master list. I came across this YouTube clip where #3 helped in my case where there was only 1 worksheet in the file (I tested one), but results in an error when there are multiple sheets that reads "Record #: Tool #: No sheet specified, you must specify a sheet." (https://youtu.be/MjGxzsMJINQ) I tried adding a comment, but it's an old clip and doesn't seem to be getting responses. Would anyone know how to distinguish the sheet to pull in using this solution? Thanks!!