Code For Button To Store Data

Hello,

I have a Record Workbook if you will which I'm trying to set up to store information. It's attached below.

Each record has a number. Each record is stored in the Historical List, and the Current List shows only the information of the latest entry of each record.

Basically what I'm trying to achieve is the following:

The Record Workbook will open to the Entry Page. When I enter a record number, my code needs to check if this number is already stored in the Historical List. If it is, then all the information from the latest entry of that particular record number should be displayed. I can make changes if I like, and upon hitting the Submit button, I should be asked if I'm sure I want to enter an update to this current record number. If I say Yes, then all the information I just added gets put into the Historical List, the Current List gets updated from there, and my Entry Page is empty once more. If I say No, then the Entry Page would just clear.

Is this difficult to achieve?