title: Merging multiple workbooks into single sheet in current workbook
body: <p>I need VBA code to select multiple workbooks by browsing the files and then merge all those into 1 sheet of current workbook.</p>
  
  <p>All multiple workbooks having only 1 sheet</p>
  
  <p>headers is same for all workbooks so header is constant</p>
  
  <p>Merging should not get any empty rows while filling workbook by workbook</p>
  
  <p>No repetition of headers when merging. </p>
  
  <p>When 1st workbook merging is done, 2nd workbook data should be merged in the same sheet of current workbook exactly next row of the merged 1st workbook data ends which means no empty rows or gaps</p>