I have a question about a macro that was posted in the 'Tips and Tricks' section.

Consolidate multiple workbooks from a folder into one master file VBA

First, I'd like to say THANK YOU to whomever wrote it, it works FANTASTIC!!

I'd like to add something to this but don't know where to begin. My excel knowledge is high but VBA skills are nonexistent.

First, I'd like to add a list of the files that have been consolidated. (I'd be placing this starting in cell K7) This will act as a check to make sure the right number have been consolidated.

Second, I'd like to be able to start the "Select Source File Folder" in a default directory so you don't always have to browse that location (all the folders will be in one directory on our server).

If this is possible I'd be extremely grateful!

Thanks,
Andrew