2 Part Macro (Insert Row + Transpose)

Hey excel maestros,

I've scoured the posts looking for an answer to this question and have had some trouble (mainly because I'm so new to macros, outside of recording them, that I don't know how to modify them).

I've attached the excel sheet I'm working with.

What I'm looking to do is have a person enter data on the "Entry" worksheet, have the ability to press a button that will then insert a row below the last line of data in the "Data" sheet. Alternatively, I have formatted the Data sheet as a table so row insertion isn't as necessary as copying the data entered to the right of the cells in the "Entry" tab and pasting it below the last line of data in the "Data" sheet.

I know how to do this with a recorded macro, but then the location is locked. I'd be stuck entering/overwriting data every time I ran the macro.

Please help! Or direct me to the correct thread/forum