Identify value and automatically puts in another spreadsheet

[osevero]

First, thanks for all the help! For this case, I want my spreadsheet "Form" identify the last value of column D of spreadsheet "Data" and put this value + 1 in spreadsheet "Form" cell E3. Here is the .xlsx 10568

I really appreciate some help,

Cheers

[osevero]

Guys I want to use the code automatically. So, the cell E3 of worksheet "Form" must have the last value of column D of worksheet "Data" adding + 1 to this value. In other words, in worksheet "Form" the value of the cell E3 (ID value) always changes automatically as the last value in column D of worksheet "Data". If no values in column D ​​then the cell E3 of worksheet "Form" gives the value 1 (0 + 1)