Macro to drag rows down

[Mstg007]

I know I can make a macro recorder to drag down rows from where I start to where I end.

I am am wanting to make a macro that I can use a user input. ( user drags row 2 down to row 54 or something). Then the macro would remember what the user selected and do the same to sheet2 and sheet3 automatically.

i hope that makes some sense.
thanks