Hello Gurus,

I need a code that user specified workbook to open and copy last row of all three sheets of sourceworkbook and paste in the master workbook in one row with header criteria in master workbook?

Example=
sourceworkbook contains 3 sheets. (source)
Master workbook= master worksheet ( destination)

Thanks