I have a large number of work books each have 5 worksheets of the same name. All the sheets contain text data. I need to read cells in the worksheets, seach for a name in the cell and depending on the name, copy the contents in a different workbook in a worksheet in the column number headed by this name keeping track of the cells. All suggestions are welcome.