Merging different Excel Files based on Tab Name

Praneeth1996

Hi team,

I have around 200 files in a folder. I want to extract information from these excel files that have tab named "Rule 3". Some files may not have that tab present and such files will have to be ignored.

Below is a sample data: File name - No of tabs - Names of those tabs

File 1 - 3 tabs - "Rule 1", "Rule 2" and "Rule 3"

File 2 - 2 tabs - "Rule 1" and "Rule 3"

File 3 - 2 tabs - "Rule 2" and "Rule 3"

File 4 - 1 tab - "Rule 1"

File 5 - 1 tab - "Rule 3"

File 6 - 2 tabs - "Rule 1" and "Rule 2"

File 7 - 1 tab - "Rule 2"

and so on for other files

I want to combine only the tabs with name "Rule 3" from these files to a new file. Is this possible? Please help.

JosephSerpis

Hi @Praneeth1996 the solution from this post should help as the first batch macro will get the sheet names you can add a filter for rule 3 and then the second batch macro will extract the data.