Arlu - Noticed you were helping this guy here http://www.excelforum.com/excel-prog...ter-sheet.html
I think a lot of what you're doing to help him would be applicable to my situation, except all of the workbooks I would like to be consolidated are in different folders. I could maybe use a list of file paths in a text file for this and the master workbook could refer to that instead.

I'd still need help doing this though as my VB is next to none.