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

[jessle]

Glad to have this one out the way!

Thanks to @OllieClarke for the help, and @NicoleJohnson's solution, which helped me create the super-condensed Version 2 (and taught me a neat little trick about the Dynamic Rename: if the multiple Excel files you're reading in have a single sheet with different names, the Dynamic Rename will still read them all in.)

[JethroChen]

Spoiler

[AkimasaKajitani]

My solution.

Spoiler

I recommend batch macro to read the files that have different scheme. 

Macro is 2 step.
Step 1 is to read sheet names.
Step 2 is to read Contents of file by Sheet Names.
Step1

Step 2

[JP_SDAK]

My solution seems to be similar to most others.  I used a directory tool to get list of filenames with wildcard file?.xlsx then passed those to a  batch macro which reads in filename+sheetname and returns all spreadsheet data including filename, sheetname appended at the end.

Spoiler

[rcarog]

Solution attached.

[mpennington]

Attached.

Spoiler

[kelsey_kincaid]

A good refresher in Batch Macros!

Workflow:

Spoiler

Macro:

Spoiler

[apathetichell]

complete with typo in the filename....

[Sashikumar]

My Solution.

Spoiler

[phottovy]

Gotta love spreadsheet without actual column names. Not confusing at all!