Hi Team,

Need your help !!!

i have 10 excel worksheets at each employee level. for each excel worksheets contains data in the first sheet and the columns of all the workbooks are same.

now i would like to merge into one excel workbook so that it will be easy for me to view the data at each employee level in one worksheet.

can you please help in writing macro code to achieve the same.

Regards,
Kamal M.