VBA macro for moving inserted data+cmbbox selection to a new table(possibly sheet)

[doesauris]

Hello,

So I'm really fresh on Excel VBA and I've no idea how to code in this language but I really need to get a work done.
The task is to select an option from a combo box (let's say a day of the week) , enter your name,surname, and phones number, click a button and that should move everything into a new sheet with a table in it. Every new record should appear in a line below the previous one, not overlap it.
If someone's done something similar before I'd really appreciate if you could share your code with me.

Thanks