Hi guys, I'm new here but desperately looking for some help after youtube tutorials have come up short.

I'm creating an inventory management system where the basis is a 'current stock' sheet in a pivot table that will be filled with all the items.
excel1.png

I figured out how to create a data entry form on another sheet by recording the macro in this sheet and then linking that macro to a button
excel2.png

So the data entry would go into the original stock sheet in image 1, but I tested it on a separate sheet as so
excel3.png

However every time I fill out the form in the data entry sheet in image 2, it overwrites the same row (seen in row 5 in example), even though I pressed ctrl and down key when recording my macro, how do I stop this?

Other than this I'd like to also know, is there away so instead of adding new data to the current stock sheet using the forms, can I create stock in and stock out forms that just edit existing data on the sheet? If so could someone please help me with this?
I'd be happy to paypal a little cash in exchange for some time and would be eternally greatful, thanks for reading!

Harriet