Read files with different tab names

[Janardhanan_M]

Hi i am working on a Project where i have close to 40 different input files, saved in a single folder, the file names and sheets names are different. Is there a solution / tool to read all the files and the tabs within them?

[JosephSerpis]

Hi @Janardhanan_M have a look at the solution from this post it uses two Batch Macros. One to get the sheet names from your excel files then another to read all the data dynamically

[OTrieger]

@Janardhanan_M Have you tried to do anything to solve your problem before posting your question here?

Simple googling would bring you to the post that @JosephSerpis shared here.