Using a VBA Macro Button to Copy Last Data Entered and Paste Into Another Worksheet

Hello All,

I have been all over google and have not found what I need. I would like to use a button assigned a macro to fill out another worksheet from the last data entered in a data table. But I am not familiar with VBA codes and I am struggling.

What the ultimate goal would be is to fill out the log, hit the macro button and have it jump to the other worksheet that now contains certain data.

I don't even know if how I am explaining it makes any sense but, I've seen it done before. Just can't figure it out for myself.

Thanks so much in advance