Copy/Paste via a Macro - How do I get it to paste into next empy cell?

Hi guys,

I have built a template sheet for recording the details of new purchase orders.
I use it to calculate a few things.
Once those calculations are done I want to copy some of the details, and paste them in the next empty rows on another sheet.

I built a button, recorded a macro of me copy and pasting, and assigned it.
It works fine EXCEPT it pastes the data into whichever cell is active on the "destination" sheet.

I want it to paste into the next empty cell in column "B" on that sheet.

I have a hunch I should be able to alter the code in the macro?
My knowledge in this area is very rudimentary...

I have attached the file and a screenshot of the current macro.

Thanks in advance.

Screen Shot 2021-08-12 at 10.00.43 pm.png

Hi Jeff,

Thanks very much for your reply.
Man, that code is pretty foreign to me, but I copied it over and it works nicely.

The "Template" page is just that - a template which will be used to create new sheets.
These sheets will have unique names.
I imagine this part of the macro code - Worksheets("Template").Range("A2:C10").Copy .Cells(LastRow + 1, "B") - will stop working if the sheet has different name? Is there a way to rewrite the code so it uses a more general reference, like the sheet the button is located on? Instead of the name of the sheet?

I suspect I'm going to need a short course on Visual Basic if I want to really start tinkering with macros.