Generating dates rang based on list of ranges with weekdays

Hi, I'm looking for a specyfic sollution. I've seen some simillar codes around here, but I admint - they a little over my head to tinker with, so could anyone look at this issue:

I have some schedules that need hour changes. I get them in tables containing date ranges, weekdays of changes, and some aditional data. What I need is a macro that would generate date list based on that table. Its in the attached file, on "range" spreadsheet. So what I nedd is a list of all dates that would occur in given criteria (like all mondays and saturdays from 12 February 2011 till 15 March 2011), followed by corresponding data from range.
The tables varrie in leght so it must be some kind of loop.

Any help would be very apreciated, or at least a solid kick in the right direction since I haven't touched VBA for few years now.

(PS. I use Excell 2007)