Hello friends: I would like your help in the following. I have a directory with several books and each book has a different number of worksheets. Manually created a book called Maestro with a single worksheet and wanted to create a macro that opens the diferents books in directory and open eachone of the worksheets of these books by copying all the rows with data. The copy should start in row 5 of the worksheets and continue as long as there is data. Control whether data is in column A. For example if a100 (a500 or A800 can be) no data, skip to the next sheet or book. All sheets have the same structure. In the end, Maestro would have all the rows of books that are in that directory. I hope letting me explain and appreciate your time and patience. my english isnt'n good. Regards