How to make combine sheets into one table for same Excel Filename

[#1]

I have various Excel files in the disk.

In one of the Excel sheet i have Day field and in another excel sheet i have date ( within same excel filename).

i need to combine into one table and date as an key. 

Pls suggest the looping with filename and concatenation logic.

[rupamjyotidas]

There would be many discussions on these in the community, try searching, below link is one of them

Load Multiple excel sheets using For loop