Hello All,
This is going to be my very first post here. So i would like to say i am glad to be here. I found this excel forum very helpful in many different occasions. So i decided to be more active and ask questions about my matters.

Today i am working on a Database using Access. I need to import all the data from an excelbook which contains about 30 worksheets. Its just ONE of the workbook we are talking about. There are about 50 to 55 workbook i need to worry about which contains 30 worksheets in each of them. I dont see myself doing this manually one by one. So i am wondering is there a macro which will copy all the data from each worksheets and put them together in a different worksheet.

These worksheets has data up to certain rows. Row 1 - 27. So i think it would probably make the job much easier? I have uploaded a worksheet using some dummy data. Worksheets 1.3 - 1.9 contains all the data. I also created a worksheet call " I Need them in this format" to show you how i wanted them to populate.

Any help or Suggestion? Thanks in Advance!

Daily.xls