Merging multiple workbooks that contain identical tabs

You were right shrinking down the file did work. Each of the worksheets in each workbook look like this.

Column A doesn't always have data. Column C (main activity) is the first column guaranteed to have data in it. Sometimes there is data in Columns A and B as well but it depends on which employee I am receiving the workbook from. Is there a way to alter the code to look up column C for the LastRow data while still copying Columns A and B in the process?

thanks again