Hi guys,
I know there's similar posts but none of them are right for what I need! I'm stuck.

The problem:

Sheet1 is the first entry file. People enter information on a unique filenumber.
Sheet2 is the second entry file. People enter different information on a different unique filenumber.

I want the unique filenumbers to be assembled in a database-sheet.

I managed a button with VBA code that copies the filenumbers to the next empty row in the database sheet.
HOWEVER, if you click the button twice, it will copy the same filenumber AGAIN.
I want the button to only update the database sheet with NEW filenumbers from Sheet1 en Sheet2.

Can anyone help me?


My code so far:

Sub CopyDataToDatabase()
Dim NextRow As Range
Set NextRow = Sheets("Database").Range("A"& Rows.count).End(XlUp).Offset(1,0)
Sheets("Sheet1").Range("E6").Copy
Set NextRow = Sheets("Database").Range("A"& Rows.count).End(XlUp).Offset(1,0)
Sheets("Sheet2").Range("E6").Copy
MsgBox ("Updated successfully")
End Sub