Hello, I have read through all of the excel import/batch macro threads and guides, however I have NOT seen a solution when importing multiple sheets from an excel file, all with possible different schema, but also being able to keep the sheet names in the output file.
My end goal is fairly simple - to stack all of the separate tabs from one single excel file so I can manipulate them, however, I also want to keep the sheet name associated with each tab so I can easily identify which sheet each row of data came from.
Thank you in advance for your help.
