paste static range into dynamic location with search

I have been looking all over google for some help creating a macro that can copy a range, search a cell, go to the corresponding cell then paste the range. I have found some things that come close but i have come here as a last result.

In the example I need the range in C7:C11 to be copied to the range D18:D22 after the macro looks to see what month to paste the range into.

The Target data B6:E11 will change as well as the date in cell C3

So next month when the month changes as well as the data i need the macro to select the data....find the right column and then paste the data.

I'm building a tracker to take a monthly report, select the target data and paste it so that way i can build a tracker to track the data and show a monthly trend in the data instead of just a monthly snapshot.

I hope this makes sense. Thanks in advanced. I'm sorry but my VB knowledge is very limited.

Looks like it works great. what would i need to add if I needed to paste to sheet2?