Create userform on worksheet that updates a table on a hidden worksheet without using vba

Hi everyone,

First time posting, but this forum has helped me a LOT. I'm sure I'm not the first person to ask this, but couldn't find any solutions. I'd like to create an input sheet in excel that updates a table (which I'd like to make very hidden to prevent users from making changes) on a second sheet. I know this is easy to do with forms and vba, but I'd like to avoid using vba if possible. Something like the data form would work fine, except I don't know of a way to call it from a separate sheet without using vba. Alternatively, I've tried using the spin control and index(match()) functions in a form created in a worksheet to scroll through records, but don't know how I would go about adding or deleting records without using code.

Any help is appreciated.

Thanks Marvin, I was hoping to avoid vba all together. If nothing comes up making an add-in may be the answer. Not sure if I need to post a new thread, but if I did go that way is there a way to load an addin ribbon only when a certain workbook is open? The main thing I'm trying to bypass is the allow macros screen. The people I'm writting for wont necessarily trust them.