VBA to copy data into next row on other sheet

Hey Guys!

I'm looking to develop VBA to do the following for the attached workbook:

When someone clicks the "Record" button on the 'DSD Calculator' Sheet, I want it to transfer all the relevant data over to the next available row (starting in row 10) to the correct columns on the 'Sales Tracker' sheet.

I'd also like the 'Date' column to automatically fill in with the day's date when the 'Record' button is pressed.

I don't know much VBA, so this part has been a challenge. Any help is greatly appreciated!

Thanks!
Matt