I'm hoping this will be easy for someone to answer as I'm new to VBA.
Here is my scenario: there is a single workbook in different subfolders of the same folder, I want to copy 1 worksheet from each of them into a new "master" workbook and keep the sheets separate. The worksheet I want to copy from each excel file is always the same name ("Status"), and it's always the 4th worksheet.
So, if it's possible the code would look through the subfolders and grab all the "Status" sheets to combine them into a new workbook.
It would be a huge bonus if the sheets being copied took the name of the file from which they came.
Thanks!
Here is my scenario: there is a single workbook in different subfolders of the same folder, I want to copy 1 worksheet from each of them into a new "master" workbook and keep the sheets separate. The worksheet I want to copy from each excel file is always the same name ("Status"), and it's always the 4th worksheet.
So, if it's possible the code would look through the subfolders and grab all the "Status" sheets to combine them into a new workbook.
It would be a huge bonus if the sheets being copied took the name of the file from which they came.
Thanks!
