Hi All
I am another newbie to VBA programming and I have a problem I need a solution to.

I am working with a master/parent workbook which contains identical copies of the worksheets from all child/class workbooks that my colleagues add data to. That is the master workbook has all the worksheets from all the class workbooks combined. I use an index page to list the names of the students in each class on the class workbooks and I have a similar sheet in the master workbook but it has a complete list of all students from all classes on it.

On a regular basis I need to transfer/copy the entered data from each class workbook onto my parent/master workbook using the list on the class workbook index sheet. I need to ensure that the worksheets in both parent/master and child/other have the same/identical worksheet name before I can transfer the data so that the info matches. That is both workbooks open and the worksheets matching. Can anyone help