Copy cell values to another sheet that is not opened

What I would like to do is to write a code that copies a cells value, and then opens a seperate worksheet (already designed) and pastes the cells value to a new row in that worksheet and then saves the worksheet.

There will be twelve cells that have information that will need to be copied, but if I can get the concept of the code, I can add all the cells if I have code for just one.

Basically I have a report form that has a good amount of information in it. When the user is done filling out the report, a command button is clicked and a save macro copies the sheet, pastes to a new sheet and saves with a certain cell value as the file name. Before/during/after this macro runs, I would like 12 of the cells values to be copied and pasted in a new row on a log book style spreadsheet.

Hi Royuk,

I am talking about both. As I am not not inputing all of my data into the logbook, I still need the saved copy.

The workbook that the form is in has a couple of worksheets. The workbook that I will be sending pertinant information to has only one worksheet. The second workbook will not be open usually.