title: Copying cells from multiples sheets of one workbook to multiple sheets in another workbook
body: <p>I am looking for a macro that copies a specific range of cells from sheets one workbook to respective sheets of new workbook. The macro would copy cells A1:HC5 from "Sheet 1" of  "Workbook1", and paste into the same cells (A1:HC5) of "Sheet 1" of "Workbook2". Then Sheet 2 should follow and then sheet 3 and so on.</p>
  
  <p>Both workbooks have same number of sheets with same sheet names e.g. Page 1, Page 2 and so on. Number of sheets in the workbooks exceeds 2000.</p>
  
  <p>I tried code from <a href="https://stackoverflow.com/questions/13976058/macro-for-copying-cells-from-one-workbook-to-another?answertab=votes#tab-top">this post</a> but it copies from Sheet 1 of first workbook to sheet 1 of second workbook. Need code that copies data from all sheets.</p>
  
  <p>Please note I do not intend to consolidate specific data from multiple sheets in to a single sheet or summary sheet. </p>