One last thing AB33,

In this new file that you send everything works great except when I try to add different sheets and run it again, it replaces the existing data.. Any way of having the macro just pick up where the first open spot is?? I do not want it to clear as I have multiple files that I need to add to this one...