Data Consolidation of Multiple workbooks in a single workbook

[Dinesh_Excel]

Hello Team,

Can someone help in finding me a code for consolidation of 30 odd workbooks data having same header in to one file.

Appreciate your help on the same.

 

[Monty]

Hello Dinesh...can u upload a sample file to see header size.

 

[Dinesh_Excel]

Hi Monty
I was able to find a consolidator Marco ( Attached for your reference)

after consolidation I have a date range column where I need to have a specific date range in that consolidation sheet and the rest should be removed.

For example from the Data Range sheet I need to select a range of date from example :

21st Aug to 25 August and the rest of data should be deleted from the data range sheet.

Appreciate your help