Hi All,

I have 7 different workbooks that all contain the same headings in Columns A:H (only one sheet per workbook). I need a macro to loop through all seven workbooks, copy the data from A1 to Column H of the final row in that sheet (it varies in length), and paste them into my workbook on the "Master Sheet" tab. However, the data must be pasted at the end of the data that is already contained in the document, so I don't copy over anything. Also, if a file is not found, I want it to skip over it.

Can anyone help? I appreciate it.