Using range in a macro from cell value

Hi all.

I am currently running a macro that takes the top 25 lines from one tab and moves to another. Problem is, sometimes I need that 25 to be a smaller or greater number. Currently I am using:

End With
    Range("A1:B25").Select
    Selection.Copy
    Sheets("Results").Select

And it works great. Can I use the cell value to change the "B25" above to read something like :

    End With
    Range("A1: (Results q2)").Select
    Selection.Copy
    Sheets("Results").Select

So it would pull the number from cell Q2 on the results tab and today for instance, it would pull the top 11 lines,

Thanks for the help!!

Chris