Import file contents (xml) from multiple zip files

Good day all - hoping for a little assistance with a bit of a nagging problem, and one for which some of my coworkers say there is no way solve in VBA.

My associates have saved about 2,000 .zip files in a single repository. Each zip file contains a .pdf, and a file called "metadata.xml" - the metadata files are small, only 1-2Kb.

What I'd like to do is import the contents of each metadata.xml file into a single workbook so I can build an inventory of the pdf files.

The full path looks like this:
Z:\Princeton\Global Data\Financial Data\Financial Data\WC\FNDL_PRODUCTION\128650_TH1X0_ProTechLLC_A_Eng_BBOT__20140317132245.195_bbot.zip

Everything up to and including FNDL_PRODUCTION is exactly the same for each file. Everything after, varies, and is not predictable.

Any thoughts on the best way to do this? I'm thinking there is some way to say "for each file in repository, import metadata.xml content..." but I can't figure out how to do that.

Thanks for any guidance!

Thank you... have used these in the past but never successfully - will give it another go.
Thanks again (sorry for the delay, have been taking care of sick kids)

Tinbendr, thank you again. I've attached one of the smaller files - I'm only interested in the metadata.xlm.

I have been able to compile the file contents by copying each "metadata" to a local directory, then importing to the first available row in my spreadsheet, deleting the local copy, then moving to the next zip. This seems to work, but is quite time consuming.

I'm wide open, and grateful, for any better/faster/smarter approaches!

JP

Tinbendr - much appreciated. This will certainly help!