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.