Copy/Paste in 1st blank row with a Button!!!

Hi Excelers

here is the exercise:

Sheet1 is for inputs, Sheet2 to create a list and Sheet3 for output

Sheet one is to write raw input from B1:H1. Afterwards I need a button to copy the entire line and insert it on the first blank row in Sheet2 Range(B:H). If the line is already writen, it should paste it on the line bellow.
Sheet 2 has conditional formatting and filters and sorts but I will leave that to later.

I have to this over and over So I would like to save the copy paste step. What should I do?
MANY THANKS IN ADVANCE

Please Login or Register  to view this content.

I changed the "A"s in the paste function to "B"s since he wants the data to start in column B.

Please Login or Register  to view this content.

Miguel, do you konw how to create the button and have this code run when the button is pressed?

Does this help?

Please Login or Register  to view this content.

Thanks RVASQUEZ! Big Advance.
So this what I did: Inserted a button and within a formula I inserted the code, just changed for sheets("Sheet2").range("B" & range("B6555") since it was on Column B.
The issue is it inserts the line random (line B1029, B956...) and I would like to do B8, B9, B10... so on..
Any Comments?

Sorry update the following line

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

VASQUEZ!! Exactly what I needed!!

What about if according to input I could place it in different from line 100 until 150. For example, if Sheet1 C5="Different" then place it in row100 or the first blank bellow100.

Thanks again for the last code!
Best