Adding a new Item overwrite the existing one previously edited

Hello everyone,
I'm seeking assistance with a challenge I'm facing. I've been working on a UserForm to facilitate the insertion of items, and I've nearly achieved the desired functionality. However, I've encountered an unexpected behavior that I need help addressing.
Upon launching the form, filling in the required information, and clicking the Save button, the new item is correctly added in a new row on the worksheet, functioning as intended.
The issue arises when editing an existing item. While the modifications are saved to the same item, if I subsequently attempt to add a new item, the new information overwrites the previously edited item.
This behavior is not present when deleting an existing item.
I've tried examining the code to identify the cause of this behavior, but being super new to VBA, I'm struggling to pinpoint the issue. Could you please review the code and assist me in resolving this problem?
Attached the file I'm working on.
Thank you in advance for your help!

Administrative Note:

Welcome to the forum.

Although we value your privacy as much you do, it could be important that members have a rough idea of your location as the solutions they offer may be affected by your locale. For instance, you might in the future post questions which are related to your regional settings.

With this in mind, please update your profile to something more precise (something such as UK, Europe, USA, UAE, etc. will suffice).

Thank you for helping us to help you.