Create data entry form for relational database setup via Excel

I started off by creating an excel file that has 5 different worksheets. The first worksheet has the master data such as name, description, etc.. The other worksheets contain related information for the master records.
For example, key 1 on master data would have 5 separate worksheets with additional information with the same key on each.
The last table has the same key but an additional key because it could have multiple lines for the same key.

I created them as tables and then added each to the data model. The primary key was establish to tie each table together. I assume the last table would also include a foreign key since it can have the same multiple key?

I now want to create a data entry form that contains the data from each worksheet that would allow me to add, update, delete as needed.

I have attached a sample excel spreadsheet with the database structure I'm trying to do.
I also have attached the data entry forms when each are separate.

How do I create a form that combines all of the information into one and allows me to update all of the worksheets.
If I can't create just one page then I would maybe try separate screens tied together one after the other for the user to enter the information.

How could I do this? Any examples to show me???

Build yourself a VBA driven UserForm.
I have attached one I am assisting a fellow poster with.
The basics are each page of the Multipage acts as a separate form although yours could easily be contained on a single form.
torachan