Hello All

Please try this macro Parsing.xlsm

In this macro taking current workbook as input it is creating new workbook with different sheets. In the same manner I need macro taking several files (having same title row) as input and finally creating master workbook with different sheets as above.

Please help me out of this. I am struggling with this from many days.

Thanks in advance

PS: Take sample multiple sheets as
file1.xlsx
file2.xlsx
file3.xlsx