Macro to copy non adjacent cells to external workbook and move down row

I currently use 2003, 2007 and 2010 versions of Excel, and do know how to record and run a macro, though I do not write VB. I have an invoice template which I bring in, fill in individual details using data validation/drop down boxes) and print off. I then want to be able to copy, for instance, data in cells c21, c12, e18, and g59 (in that order) to an external workbook in a row format so that at end of each month I have date, name, ref and total in tabular format. I can easily write the macro copying the data over to the other workbook but can't get it to move down one line so that when I copy a subsequent invoice data over, it doesn't overwrite what was previously pasted. I would appreciate any help.

Hi,

This is exactly what ive been looking for. I know this is an old posting but was hoping someone may be able to help.

I need to do exactly what the original poster wants to do but i need to ammend to suit the following criteria:

Is it possible to have the SourceSheet as the invoice i have opened rather than as its file name? Also is it possible to copy the cell info to a closed workbook?