merging multiple workbooks into single sheet in current workbook using VBA : I need VBA code to select multiple workbooks by browsing the files and then merge all those into 1sheet of current workbook.

All multiple workbooks having only 1 sheet

headers is same for all workbooks so header is constant

Merging should not get any empty rows while filling workbook by workbook

No repetition of headers when merging. 

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