Copy/paste based on date criteria

[STST07]

Hi,

VBA beginner here. I have tried searching for a solution to my problem, but was unfortunately not able to find a code that works..

My issue:
I have several sheets of data all from row 3 to 7, column B to M. Based on a date input I need to paste the values in one column range for each sheet. For example, if I enter period February, the macro should copy and paste the data in cell B3:B7 in sheet A, B, C, (to the same place, just to remove formulas). Next time I load data and enter March, and run the macro it should paste the data in C3:C6 in the same sheet and so on (total 12 periods).

I have attached an example file if that is easier.

Any help would be highly appreciated!

 

[AlanSidman]

To be sure I understand, Copy the Data in each sheet and then paste it back to the same location in each sheet as values (no formulas).

 

[STST07]

Yes that is correct. I need to hardcode the formulas.