As for best route, (Sorry didn't answer in my previous response) in my limited experience of copying code from one workbook to another, I would have the code obviously already written in your "source" workbook. Then when the summary workbook is created, to copy the code over to the summary workbook where/however you would like it.

One thing I'm not sure about, is if you can use the method that was described to copy the code for ThisWorkbook...

I had personnally found a different way around this in a program I wrote a few years ago, but it was/is rather complicated... Probably I made it more so than was necessary, but it worked. :)