This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Can I combine multiple excel files, but instead of putting everything into one sheet, I want to copy the sheets on each file and MOVE them to the new file? So for example, I can have 4 files for each quarter, and each file has a tab or sheet for each month corresponding to each quarter. I want to create a file for the whole year that will show me the monthly tabs coming from the quarter files (Jan-Feb-Mar from Q1 - Apr-May-Jun from Q2, etc). But again I don't want them in one sheet, I want them in their own sheet. Obviously, I know how to do this manually, by moving or copying the sheet. But sometimes I have to combine more than 20 files into one and don't want to be moving 20 or more sheets, one by one. Thank you!!
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Open a workbook.
Right-click any of the sheet tabs.
Select 'Select All Sheets' in the context menu.
Right-click a sheet tab again.
Select 'Move or Copy' in the context menu.
Proceed as usual.
Alternatively, it would be possible to create a macro to do this for multiple workbooks. Let me know of you want that.
Thank you
You are very welcome!
I'm glad you found solution to your problem..
Regards
Jeovany
Hi Valeria
Power Query will be the best and more dynamic approach to solving your problem.
The instructions in this video will lead you to the solution.
If you have trouble implementing the steps, then provide us with a sample copy of the 4 files so we could work on the solution from our side.
Regards
Jeovany
I can't help you with Power Query, sorry!
Yes that process you describe is what I normally use. I have seen many posts and videos about using power query to combined multiple sheets or multiple files into one sheet, but I have not seen anything to do what I mention through power queries.
Thanks!