Help me to consolidate 10 excel sheet data in one sheet

[Gnanaprakash1]

Dear friends,

I have a 10 excel files in one path, i want to consolidate all the 10 excel data in one excel sheet by based on Start date and End date.

I have attached Check_4 excel for sample file for 10 excels, Master file i have attached for output

Criteria 1 : Data should be consolidated only from the sheet name "Process tracker "

Criteria 2 : Data should be consolidated only which data we are selecting in the master output file( the dates in the Check_4 file B column).


Friends please help me on this.