I wonder if the following is doable?

I enclose a copy of my Purchase Order template.
What I would like to do is to copy the data circled in red (I've put the cell references alongside them), and paste them in the next available row on Sheet 2, so I have a record of what has been ordered.

Is it also possible to save the Order automatically as a PDF using Supplier name, Customer name and order number as the file name?

Purchase Order Template1.jpg