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.