Consolidate with the same header names

Want to consolidate different excel file tab but with the same header name. How to do it?