VBA Userform - Search, Edit & Update functionality

Dear Excel Forum users,

I have created the attached database including a VBA Userform ‘MacMonitoring’ (linked to the ‘MacMonitoring' worksheet) which allows me to add a new client to my database (MacMonitoring sheet).

I have replicated the User form and called it ‘MacMonitoringUpdate’. I want to use the replicated form to add a 'Search' and 'Édit/Update' option, presumably using command buttons within the Userform itself.

I am struggling to come up with VBA code. When searching i'd ideally like all the criteria in the userform to populate based on a surname or first name search with a 'Find Next' function. When executing the Edit/Update option i'd like it to replace the row of existing data rather than populating a new row.

Any help would be much appreciated - sorry i had to send file as a zip file.

Thanks
Motoka