Ok, I have 3 separate workbooks, and each workbook has many sheets inside, the sheets names are named using numbers, like: 1, 2, 3 and so on.....
So I can have a sheet named: 1 in each of the 3 separate Workbooks.
I am looking for a way to traverse through all 3 of the workbooks, and any sheets that match each other with the same sheet name, copy them into a new workbook while keeping the same sheet name.
So if I find sheet name: 45 in each of the 3 workbooks, I would need to copy them into a new sheet named: 45 and append each one below it's self. Any idea on how to do something like this ? using VBA ?
So I can have a sheet named: 1 in each of the 3 separate Workbooks.
I am looking for a way to traverse through all 3 of the workbooks, and any sheets that match each other with the same sheet name, copy them into a new workbook while keeping the same sheet name.
So if I find sheet name: 45 in each of the 3 workbooks, I would need to copy them into a new sheet named: 45 and append each one below it's self. Any idea on how to do something like this ? using VBA ?
