Daily macro to pick up from multiple sheets

[DaveSmith]

Hi,

We have multiple excel sheets that are exported to Excel files on a daily basis to folders to 7 daily folders - Mon, Tues, Wed, etc, then what we do is manually move them to the day they are for. I.e. the files for yesterday, we would cut and paste from the Tuesday folder to the folder titled 22nd February.

I have limited experience with Macros and especially VBA, but I would really like to create a macro so that on a daily basis each tabbed worksheet on the Call Line Pattern 2011 main worksheet would pick up data from the multiple sheets.

So the row for:

Line 1 tab, row 5 would pick up from
Call Line Pattern\2011\1. January\4th January\Line1.xls

Line 2 tab, row 5 would pick up from
Call Line Pattern\2011\1. January\4th January\Line2.xls

Right up to Line 6 tab, row 5 which would pick up from
Call Line Pattern\2011\1. January\4th January\Line8.xls

The files that we want the sheets to pick up from are all the same name every day. The only difference would be the name of the folder that they are picking up from which would be the date.

Could you tell us the best way to run a Macro for this please? I have studied some macro videos but they didn't cover such a scenario. I couldn't find any similar examples in the forum either (unless I have overlooked?).

I have attached the main sheet with a couple of days worth of data in the zip file to give you an idea of what we are trying to achieve.

Thanks.

Dave

[watersev]

hi, Dave, please check attachment. Run macro "test". You will need to select folder with the date you need to import (I've tested it on the 4th January folder). I found out that in the main sample file some time ranges were missing so they were added. On my part everything works as it should.

[DaveSmith]

Hi Watersev,

Hey, you know I forgotten where I posted this question and just found it again, so please forgive my tardiness in response. Many thanks for this. This does work as you say when I run the test macro and is exactly what we are looking for.

Could you tell me what I need to do to create such a macro in our own sheets or where I could learn how to create such a macro in the simplest possible way. Although I am quite good with code (mainly HTML/web code) and could probably pick it up eventually, VBA code seems a bit more complex to me.

Thanks.

Dave