Namaste Gurus of VBA macro excel.
I am using this code:

 'DINERO EN TEXTO
    Select Case Left$(Range("C51").Value, 3)
    Case "1"
   Sheets("MESESPAST").Range("Q04").Copy
        Sheets("RECIBO").Range("E31").PasteSpecial xlPasteValues
    End Select
To copy data from one sheet to another.
1) But cases are more than 50.
2) C51, E31 don't change for all these 50 cases.
3) But Q04 change... for case "1" correspond Q04, for case "2" correspond Q05
and in this way... 3 ----- Q06, 4 --- Q07...

There is maybe a "Magic Code" that can use for no write 50 times the same structure?

Thanks for your help.