Copying data between sheets without duplicates

[artilheirogomes]

Hello Masters,

I'm in need some assistance, i believe the code is not hard but i tried already a few options and i cannot figure out the reason is not working

As you can see in the picture above i have the test details from user 1 (left table) and there is the main registration on the right side. I have now total of 3 users each one with their own file with serial numbers.

My difficulty is on grabbing all the information from User 1, User 2 and User 3 (each one with a file similar) and grab all the information into 1 single file for each tab on the right table (1 File with Main, User 1, User 2 and User 3), also cannot be copied duplicated values.

The cell values from each user will be only the SN and time taken as you can see in the following picture

Notice that the time is 00:00:00 because also on the left table is also 00:00:00, but the idea is to grab the total time taken for each SN.

Can someone help me with this?
I appreciate the help.

 

[artilheirogomes]

Sorry, by this I mean the workbook that has "Main" worksheet and other worksheets for respective users.

On the Admin sheet the name is Main, Charlotte, Michel and Steffan. The other workbooks the name of the sheet is just "Sheet1"

 

[kanadaaa]

On the Admin sheet the name is Main, Charlotte, Michel and Steffan. The other workbooks the name of the sheet is just "Sheet1"

I just confused the Tracking workbook in the image in #1 with the EOL Admin workbook.
You'll just want to put the code into a standard module in the workbook on the right in the image in #1.

 

[artilheirogomes]

Is working. Thank you for your help Kanadaa (Y)

 

[kanadaaa]

You're welcome and thanks for the feedback

 

[artilheirogomes]

You're welcome and thanks for the feedback

Always welcome. If i need further assistance i will let you know. ???