hello dears

please, help me to do this task, as i failed to make it allone, and i usually do it manually.


i've foldar for y17 contains 12 foldar named by month, each one contains from 20 to 25 workbooks day by day ... i want to coppy data from each workbook into mastersheet
note: every workbook contains only one sheet.
i usually use office 2003 on my pc and office 2016 on laptop, so hope code run on both.
attached a sample file for day-wb and master sheet.
thanks for your help.

Attached Files

	form1.xls (23.0 KB, 9 views)
	master.xls (13.5 KB, 9 views)