Sorry. I post a lot of code here and some of it I create for the poster on the fly rather than pull out of my code base but I draw the line at writing code for someone else for free that I wouldn't write for myself. Besides, I already told you how to do it.
You need as many insert queries as you have tables to insert data into. You need to pass them arguments that include a value for the foreign key so the new records will link to the correct parent record. Then you need the code to run the queries. use the DoCmd.OpenSQL method to run each query. If you have 5 insert queries, you will have 5 lines of code. I think you can handle it. At worst you have 10 lines of code if you create the SQL strings separately.