I have 70 Excel file and in every excel workbook there are 10 sheets.
But every workbook has SAME Sheets NAME'S like { Excel 1: JAN , Feb , March } & { Excel 2 : Jan , Feb , March } & { Excel 3 : Jan , Feb , March }. The Excel are kept in a single folder.
How to consolidate the Excel by Sheets NAMES. I want to Copy and Paste the data like Sheets JAN to JAN , FEB To FEB , March to March . Using VBA Macro or any other ways to Merge or copy and paste all excel sheets by their name, in a single time.