VBA Code to move sheets from different workbooks to a masterfile

[Mel0620]

Hi - I am trying to consolidate different a specific sheets from different workbooks into 1 workbook maintaining the pivot format and formulas

Here's what I am trying to do:

1. Copy or move the data from sheet 1 with specific names to a single workbook
2. Data is in Pivot form/Data only
2. Sheet name should be in order based on the lists
3. Error in opening the file should be resolved as well

 

[Mel0620]

Hi - I am trying to consolidate different a specific sheets from different workbooks into 1 workbook maintaining the pivot format and formulas

Here's what I am trying to do:
1. Open the workbook from specific folder based from the lists
2. Copy the data in specific sheet
2. Paste the data to another workbook
3. Rename the tab

Here's what I am trying to do:
1. Open the workbook from specific folder based from the lists
2. Copy the data in specific sheet based on the lists
2. Paste the data to another workbook
3. Rename the tab same from the original workbook
4. Open again next workbook based from the lists
5. Copy the data in specific sheet based on the lists
6. Rename the tab same from the original workbook
7. Repeat until the lasts lists
8. Save the workbook as binary