Good evening all,

I have the following problem:
One main folder "2012", subfolders "Month January", "Month February", ... , "Month December" and within each subfolder four to five week-files "Week 01", "Week 02",..."Week 52". Each "Week xx"-file has the sheet "Data" which i would like to analyze.

I want to gather all week-data in one consolidated Excel-sheet of 2012. Thus, the rows in Week01-sheet Data are copied in the consolidate sheet, the rows in Week02-Sheet Data are copied directly under it and so on...Difficulties are that only the rows starting from Row 11 must be copied into the consolidated sheet and that the number of non-blank rows differs within each Week xx-"Data" sheet.

Does anyone have an effective solution for this?
Thanks in advance!