Challenge #499: Where is Waldo?

[Nicholas_14]

Used two macros, one for enumerating sheet names for a specific file, another for going through each sheet of that particular file to search for waldo. Fun challenge. 

[alineruizcampos]

Spoiler

[Pilsner]

I went the macro route as I wasn't sure if the schemas differed; however, this may have been a bit overkill!

Spoiler

Looking at others' solutions, I like @jrlindems approach of using the ".*" wildcard in the regular input tool, to help get all the sheet names; it looks much more efficient than my directory -> batch macro.
Here's my workflow:

[Kilbyflow_Designer]

Complete!!

Spoiler

 

[jtmoll]

Spoiler

[Reesetrain2]

All,

My solution!

Spoiler

 

[AkimasaKajitani]

My solution! I created the Iterative macro that the workflow will stop when it finds the result.

Spoiler

[Carolyn]

Found him!

I had already thrown in the 2 macros when I realized I could have just done the Dynamic Input. Oh well :)

Spoiler

Workflow:

 

Macro to get list of all sheets:


Macro to import all data:

[Bobbyt23]

Fun challenge to start the new Year with.

Spoiler

[lwolfie]

Great start to the new year.