I have five spreadsheets with same columns and I need someone to write a marco to copy and paste them into one worksheet.? Now, the number of rows in each of those separate worksheets are different.? So when copy and paste to the main worksheet, it must be a continuous process instead of overwriting the data.? Can you help?? This should be an easy macro.