Transfer Data from Checkbox List to Summary Table

Hi Everyone,

I am new to the forum and this is my very first post so I will try my best to explain the problem.


I am creating a from where the user has to select checkbox to indicate which emergency drill was completed. if the drill is not on the list there is a field for "other" to indicate the appropriate drill. I have also created a register on another tab to provide a summary of the drills that were performed. The idea is, once the form is complete a "complete register" button is selected which transfers the relevant data to the register. My problem is, I don't know how to change my VBA to transfer the data from the checklists to the register. I also don't know how to set it up to look at the "other" option if a checkbox is not selected.

Just a note, I'm very new at this and everything I know I have thought myself through googling and YouTube videos so if possible please explain in a way for someone like me to understand

Thank you!
PS: I hope the explanation makes sense.