How to consolidate Excel sheets or merge it
<p>I have 70 Excel file and in every excel workbook there are 10 sheets.</p>

<p>But every workbook has SAME Sheets NAME'S like <code>{ Excel 1: JAN , Feb , March } &amp; { Excel 2 : Jan , Feb , March } &amp; { Excel 3 : Jan , Feb , March }</code>. The Excel are kept in a single folder.</p>

<p>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.</p>

<p><img src="https://i.stack.imgur.com/f73Vd.jpg" alt="Images[1]"></p>