Combine Worksheets into Current Workbook

[rocketboy13]

Hi,

I am using this code to combine a series of specific sheets from a group or workbooks into a single sheet. It works great, does exactly what I need it to do. Except it combines the worksheets in a brand new workbook. I want to run the macro from a button on WorkbookA Sheet 1, and have the data show up in WorkbookA Sheet 2. I'm pretty inexperienced in this stuff, can anyone show me what I need to edit to make this work?

Thanks!

Please Login or Register  to view this content.

[rocketboy13]

Just figured it out. Thanks!