Copying Worksheets from Multiple Workbooks to a Single Workbook, Separate Worksheets

Hi

As per attached file, i am trying to copy data from file Input data.xlsx to Output data.xlsx

My requirements are as given below -

1. To copy all worksheets from Input data to Output data

2. Input data and Output data is having fixed format and hence macro needs to copy data only from below cell range of input data -

Range1 - B5:I7
Range2 - B8:I42
Range3 - B43:I51

3. Output file data range is as given below -

Range1 - B3:I5
Range2 - B7:I41
Range3 - B44:I52

4. Macro should copy data only where worsheet names (e.g. - 0148000000 - OFFICE OF AUDITOR) and expense heads (e.g. - E006 - EMPLOYEE COMPENSATION) are matching with output file

5. Macro should ask user to select directory / folder where Input files are saved

6. Macro should give message how many worksheets are copied in Output file and should throw errors or mismatch report (if any) in new worksheet

7. Please also note that, thought formats for Input files and Output files are same, there are many input files and output files in a folder and also number of worksheets are also not constant.

Thanks in advance for reading and helping me to resolve my problem.

with best regards,

Abhijit A.