Excel: Combining select columns from multiple worksheets into one new worksheet

What I want to do seems frustratingly simple. I have about 10 sheets within one workbook, one for each department I am dealing with. Each sheet is structured the same way, with the same column headings. I want to create an overview worksheet that would pull the basics from each sheet and combine into one large table. Ideally, the worksheet name would be in column A on my overview page, and then I'd pull the text from columns A,B,D,G and K from each sheet to create the master list. Macro?

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

This thread is current as of August 08, 2014.

For more resources for Microsoft Excel