Hi,

After I import multiple text files in excel in seperate sheets in same
workbook, I want to consolidate them in one sheet. First row of each
sheet has same headers so during data merge it should not get first
row of sheet2, sheet3, sheet4.

I want to run this macro seperately from first macro i.e. import text
files so that I can first check all sheets for proper data integrity
manually.

Any help would be appreciated.