Excel Get data from other workbook file (with some data handling) -

i'm trying make excel-document ("target document") automatically updates information excel-document ("source document"). new data added source document time time , when target document opened must contain new data added source. every new row in source must copied target, , every row has "order number" makes unique , identifiable.

i can't use links because later changes in source document shouldn't cause changes target document.

how do this?

edit: planning on doing in vba.

you can adapt , modify code @ http://usefulgyaan.wordpress.com/2013/04/26/export-data-one-excel-file-to-another-without-opening-them/ when target workbook opened, updates data source workbook.