I am looking for a way to copy a row of information from one workbook to
another.

A user sends their Workbook to us (Workbook 2). We open it and copy his/her
information in row 2 to the Master.xls

Workbook 1 file name is Master.xls
Workbook 2 file name changes

Need to copy row 2 from Workbook 2 to the next available row in Workbook 1
then save and close Workbook 1.

Thanks in advance!

Dwight