VBA or macro to autofill sheet 1 from sheet 2 using date ranges and names.

[slstang65]

Hello I was needing some help creating a macro or script to take the data from our team schedule and add it to a work summary report that I have to do. Please see the samples below. Each month I would be looking to update a new sheet with the monthly schedule.

From this,

<a href='http://postimage.org/' target='_blank'><img src='http://s17.postimg.org/yf8h5iajj/sample1.jpg' border='0' alt="sample1" /></a>
To this,

<a href='http://postimage.org/' target='_blank'><img src='http://s17.postimg.org/r0sc4m3fj/sample2.jpg' border='0' alt="sample2" /></a>


Thanks for any help you can provide.