How to create a form that logs data?

Thank you for that. I may be in over my head here, but where would I apply that code? To the button? Would that constitute the macro?

I created the simplified picture to visually explain what I'm trying to do, but perhaps it would be helpful if I just attached the file that I'm actually working on. I put a button in there, but wasn't really sure what to do with it.