Copy & Paste Rows Using VBA

Hi Guys, I hope you are all having a great Friday

i was just wondering if anyone could help me. I currently have an order form set up B7:D69 with with the following columns B) Product Description C) Item Code D) Quantity. What I was wondering if anyone knows of some code that would only copy and paste the rows that had values in all 3 on to sheet 1 and then if you were to change the product would copy and paste the next "order" on to the line below the previous request? so you would end up with a sheet of multiple products with qtys

any help would be greatly appreciated

Jamie

I can see the "before" and it looks like none of them have all three columns filled. I get the idea of copying a line if it has information in Columns B, C and D. What I'm not getting is the "if you were to change the product" part. Perhaps a walk-through of an example or two to present the "after" would help.