Macro to replace line of data within a table

Hi all,

I have a problem where I've created a sizeable table of data that creates short range programs and workflow trackers, but the end user that manipulates the table has limited excel skills and understanding which of course then effects any worksheets/formulas that come off this table.

I had an idea where I could create a user form that looks up the content of one line in the data table but displays it in a much more user friendly manner. The end user could then type over this to update the contents of the table by pressing a button(macro) that transfers the new content of the user form to appropriate line in the data table. There is a third sheet that mirrors the data table exactly but then is just equal to the cells in the user form - so this would be the one to update the data table with.

I've attached a sample workbook that I think would better explain it but any help would be greatly appreciated as this is causing a bit of a headache.

Many thanks,

Jason