Challenge #118: Think Like a CSE - A not-so-wild-wildcard input!

[Thableaus]

Here's my solution

Spoiler

Just to make sure I was bringing everything dynamically, I first captured the sheet names in the 1st batch macro, then I read the data all through in the 2nd batch macro using the Full Paths built in the 1st macro. Have no idea if this is the most optimal solution but probably very dynamic I'd say.

Cheers, 

[DataHabanero]

Oldie troublesome value format!

[aravind_sk]

Used batch macros for the solution. To get sheet names and then to open all the sheets in all files in folder.

Spoiler

[MUHAMMED_NABEEL_P]

Combination of 2 macros 

[Jishnu_K]

Used two macros to pick sheet name and open all files.

[tammybrown_tds]

Solution.

[JasonHu]

Here is my submission, perfect use of wildcard macro from crew macros.

Spoiler

[Laurap1228]

Love a good batch macro 🙂 

Spoiler

[jonathanwillis]

Here's my solution

[TheOC]

The answer, as often is....

Spoiler

BATCH MACROS!