Copying data from multiple workbooks and different columns

Hello. I have a question: If I wanted to copy data from, let's say two different workbooks, with data in row A:B and then E:F. I want to copy the data into the same columns in the master workbook. BUT, the problem is that there is more data in columns A:B than in E:F (that is there are more rows). Could someone show me an example code of how to paste data after the last piece of data (for the first copy it would be easy because it would be in the first row). Also, if there are any links describing this that would be great. Thanks

This destination will copy to the Last row in Column A

Please Login or Register  to view this content.

Just change the Column Designation for the other three. If that's what you mean.