How do I update table data using a separate form?

[NeonOne51]

I have a table of data arranged in columns, the usual way. I want to call in the data from the table into a separate form on another worksheet. Then, I want to be able to update the data without leaving the form. (I.e., I don't want to be forced to update the data in the table directly; there are too many columns and rows to search through.)
How do I create a form to do this? I suspect the solution uses some form of VLOOKUP, and I know how to do that part. (I can successfully display the data using the form, but the only thing I can edit is the formula in the cell, not the data is is calling up.)

 

[AlphaFrog]

Consider using the Data Form feature built into Excel...

Add, edit, find, and delete rows by using a data form​

 

[NeonOne51]

Consider using the Data Form feature built into Excel...

Add, edit, find, and delete rows by using a data form​

I have considered it. That feature only supports data tables with up to 32 columns. My data has over 50 columns.