Merge many sheets into one - don't copy a few sheets

[Michelle Deigh]

I have two sets of code I have written, one is pretty basic and was fairly simple and I managed to avoid the sheets I don't want but it is copying each sheet on top of each other so I end up with one. The other is copying correctly but is copying each sheet. I can't just merge the codes cause like an idiot I tried a totally different manner. I am guessing that the easiest would be to fix the one that is copying the sheets all into the same location. ANY IDEAS? If you need the code I can add when I am back at work, I am just still thinking about this - UGH!

Thank You!

[davesexcel]

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic