Macro to cut and paste a variable number of rows to a variable location?

Hi all,

So my VBA skills aren't great and this has me stumped...

I have 2 sheets, one called 'Plan' that tracks project work with columns that contain lists and formulae that I want to keep consistent. The other is called 'Template' and contains an unpopulated version of the populated columns in the Plan sheet but with the lists and formulae in.

I am after a macro that will copy the unpopulated 'Template' rows, and paste it into the 'Plan' sheet. However, I want to be able to specify how many rows to paste and at what row number location.

I am guessing this will require a macro that has a lookup to a numeric value in a cell to specify what row number to inset at and another lookup to another cell that contains the number of rows to paste (possibly letting the macro know how many times to loop).

I have attached an example with the macro I currently have, which simply pastes in a bunch of lines at a fixed location.

Please let me know if any further information is required.

Really appreciate any help on this!

Cheers,

Chris

EDIT: Ok so the macro in the example doesn't work because I changed the name of one of the sheets. You get the idea though.