Many thanks for your reply. Somehow I still can't get it to work.

Master contains 3 sheets
Each sheet has row 1 like:
Col_A Col_B Col_ C Col_D Col_E Col_X COL_Z
bla bla bla ABC DEF GHI TOTAL

ABC, DEF etc are employee names.
The number of employees can vary (so on sheet 1 I have 3 employees,
while sheet 2 has 7 employees and sheet 3 has 2 employees.

While running my code, I want to make sure that 3 + 7 + 2 = 12 sheets
are present in the specified directory. The names of the sheets must be
the same eg ABC.xls, DEF.xls etc.