There are several dozen such posts and samples within the forums, almost the same exact title...

Do a search to find many examples. This one seems appropriate to your scenario..
http://www.vbaexpress.com/forum/show...iple+workbooks