Tim, I have written several macros that do this very thing. My girlfriend is a sales coordinator, and used to have to take a zillion workbooks and combine them etc. It would take hours to do it all and then prone to errors etc. I don't want to spend time with this if others are writing something for you, but I would be willing to help you if you wanted to contact me directly. Take out the X's and ths stuff between the X's in the shown email address.