Cant copy form data to worksheet, new row.

[kwik98]

I have a form (Timesheet) that is filled out daily with dropdown boxes in some cells and formulas in others and just data in yet others. What I am trying to do is create a VBA and button so that once my form is filled out, I can click the VBA button and insert the data from certain cells in my form (Timesheet), into the first empty row of DestSheet, all in one row. The empty row has no formulas or anything in the cells. Each column will have a unique header label.
I fill out two and sometimes more forms a day, each day, so I need the information saved and added to each time I finish a form and click the VBA button. The form is saved after in another location.
Seems simple enough but it has me stumped.

[jaslake]

Hi kwik98

Fill out a time sheet or 3 or 4 and fill in the DestSheet with the data from the time sheets so we can get a clear idea of where the information is pulling from and where it's going to go. Then, perhaps we can help.

John