I am new to Excel Programming. Now, i need to create a macro to copy the data from time sheets of different employees into the Master sheet. ie., each employee's time sheet details in to a separate sheet. if any employee fails to provide his/her time sheet details. a mail must be sent to the respective employees regarding the Time sheet submission. i am providing the sample data of my files too. please provide your suggestions.