Create a macro

I hope you are well.

Do you know how to create macros?

I want to create a table of data with information about vehicles.
The headings for this table can be found in Sheet2 of the attached spreadsheet.

I would be pasting data into Sheet1 that I would want to be transferred to Sheet2.
As you can see the data in Sheet1 would be pasted into a single column.
I'd like a button that copies, pastes and transposes the data in Sheet1 into a table on Sheet2.

Potentially there will be hundreds of rows in the table on Sheet2.
I will be copying the data into Sheet1 from a website and it comes out in this single column format.
So I would be overwriting the data in Sheet1 many times and would need it to add a new row to the table in Sheet2 every time I press the button.

I hope my request makes sense.

Is this possible?

Many thanks,

Jessica.