Excel: Combining Multiple Worksheets into one new Worksheet VBA

Hello guys, I need some help. I have imported worksheets from multiple workbooks into my master workbook, although now I need to be able to combine these all into a "Combined" Worksheet. There are no headings, although will need this new worksheet to start on the second row, leaving a gap for headings to be added in later. They should loop through one at a time grabbing the information from each worksheet, putting them into the new "combined" worksheet and then deleting the other worksheets. Thanks for any help, I have no clue how to do this, have looked around for a good 30-45mins found lots but nothing that works quite how I need it. p.s. There will be ONE sheet that will NOT be combined with the rest. It is called x1.

This question generated 6 answers. To proceed to the answers, click here.

This thread is current as of May 04, 2015.

For more resources for Microsoft Excel