Help with VBA: Pasting a range to a specific sheet in the same workbook

[theDoc]

I have a macro that formats data on a worksheet, but I want to add code at the end to copy and paste a range to a specific sheet in the same workbook based on a value.

Once my macro formats the sheet cell B2 will show "January", I need range A1:H8 copied and pasted to the "Jan" worksheet to A1:H8.

Next month cell B2 will show "February" so I i run my macro and then will need the same range pasted to "Feb" the worksheet and so on..

Any help with this is much appreciated.

 

[VoG]

Try

Range("A1:H8").Copy Destination:=Sheets(Left(Range("B2").Value, 3)).Range("A1")