Use button on sheet to transfer data based on todays date

Q

Qaspec

I have data on sheet1 that I'd like to transfer to sheet2. The destination
cells are the same but the referenced cells will change depending on what
month we are currently in. Here is what I need. I want to use a command
button on sheet 2 to do this. Please Help! If more explanation is necessary I
will be more than happy to clarify.

Detination cell sheet2 G9

is today is in
Jan05 sheet1 a38
Feb05 sheet1 b38
mar05 sheet1 c38
apr05 sheet1 d38
....until dec
jan06 sheet1 a74
feb06 sheet1 b74
....until dec
jan07 sheet1 a110
feb07 sheet1 b110
.....until dec
jan08 sheet1 a146
feb08 sheet1 b146
....until dec
 
Top