Merge Multiple workbook sheets into one workbook

Aug 6, 2014
Reaction score

I am using Microsoft Excel 2010. Every Monday I use SQL Server reporting services to run weekly reports and save them to Excel. There are 7 reports that same as 7 separate workbooks. I then create a Master Excel Work book and keep it open then open all the other workbooks and right click on the 1st sheet (the first sheet always contains the report data) and use the copy/move option and select the master workbook.

This is currently a long process. Is there a way I can copy 7 workbooks/sheets onto to one master workbook?

Thank You


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question