Copy row to new sheet depending on cell value <0 (First post)

[AwesomePossum]

Hallo MrExcel

I have for some time tried to find a solution for this, both on google and on the forum. Unfortunately i have been unsuccessful, therefor I'm now turning to you in the hopes that you might be able to help me.

I'm trying to get excel sheet #1 to copy data from several rows to Sheet#2 if there is a value written in first cell of that row. For clarification please see uploaded pictures here https://imgur.com/a/oSjadHG

I'm assuming this can be achieved with VBA, however my skills are limited and i sure could use a helping hand.

Final result:
I want a purchase order where employee simply write the number they need in a large order formula, and then excel should automatically copy that specific row to the next sheet so at that point, only what is needed is on the new order form. Furthermore i would like to add a couple of columns & a single row on my sheet #2 . (as can be seen on the uploaded pictures)

I hope i made my request clear, and that someone is able to help me out.

- AwesomePossum