Workbook With Userform - Monitoring Data Entry

I have a requirements to do a simple monitoring data entry. Composed of 1 admin and 10 users. These 10 users are assign to a different lines basically every lines have assigned user.

These 10 user will do a data entry. once they are done on the data entry the Admin will update those entered by the users based on ticket number and the users can browse those updated records.

Every users per line have assign ticketnumber that start in "L1"&YY&MM "-"001" this compsed of lines + year+month and numbers.

For the users side. Right now i have already created a workbook with userform to perform data entry by user (samplefor line1 and line2 user).

It has also a viewing form to view by the users if its already updated by the admin. i put also an events if the admin work book is open by other user they cannot access the workbook.

For admin side. I created also a userform for updating the records entered by the users to update records admin will enter ticket number to textbox.

This is the reference to find and search those records that belong to a particular ticket number and lines which will be updated by the admin.

Right now, I am doing records consolidation for both user and admin records. I have a button for both admin and userlines to perform consolidation. Once the user entered the records admin will capture those records and copy to the workbook used by admin to perform update. Then once the admin perform update the user will capture those updated by admin and copy to the workbook under the user.

Basically they have separate workbook for their entry and database.

Right now I encounter some issues which I think this will affect the integrity if records. Sample like once i perform consolidation it create duplicates records.