I have created a loop which will look into a directory and list and open the files in chronological order. What I want to do is as the loop is running, is to copy data from the opened file into the workbook I am running the macro from: with each sheet copied being copied onto a new sheet in the master workbook. Is this possible? I have tried to do this before but in keeps indexing as sheet1(1)sheet1(2) (and running out of indices) rather than sheet1,Sheet2. Help??