Move Multiple Worksheets From Multiple Workbooks Into One Workbook

Re: Move Multiple Worksheets From Multiple Workbooks Into One Workbook

Quote from zraines

I need the code to write a macro that does the following:

I have multiple workbooks in a folder labeled "final". I need to count the number of workbooks in that folder and then open each workbook up and move the fourth through sixth worksheet in each workbook to a consolidated workbook. The consolidated workbook will be in the folder above the "final" folder so it will not be counted.

open the workbook you wish to do this from
start the macro recorder and perform the procedures you wish the macro to do then go the the module and check the results.
post back if you get stuck
HTH
toe