Macro to Move cells from one sheet to another if conditions meet


I have Sheet with Two Columns and several rows.. This gets edited each week. But i want to copy these values onto another sheet. with similiar rows and multiple columns ( Spread by week).

For common, i have week Nos listed on both page.. ( Like Week 41, Week 42).

So in my master 1st page, if i change the week to Week 42, then running a macro. i should get the values of rows amd columns onto the second sheet column labeslled week 42/

How do i create a macro to run this automatically.