Copy Specific Text and Paste to the Last Blank of another sheet

[jei eusebio]

Hi again guys ..

I have data taken from a clients site and I would like to move it to another sheet so I can organize the data and add some formulas .. data comes in the format that I have posted below .. thats just for 1 employee .. is it possible to copy the data from the Employee name until the last Activity to another sheet by using a formula? or maybe a macro that would continually do that action? Every employee data starts with "Employee: Name" & ends with Activity Type and Adherence at the bottom. Thanks in advance guys! :D

Employee: Aguilar, Zul
'Actual' Level
From To Duration Activity
8:30 8:35 0:05 OT Cancel
8:35 9:30 0:55 OT
9:30 12:15 2:45 Phone
12:15 12:30 0:15 Break
12:30 13:30 1:00 Phone
13:30 14:00 0:30 Lunch
14:00 14:30 0:30 Phone
14:30 14:50 0:20 Phone
14:50 16:00 1:10 Phone
16:00 16:15 0:15 Break
16:15 18:00 1:45 Phone
18:00 19:00 1:00 OT
Activity Type Adherence

 

[Somendra Misra]

Hi,

Can you post a sample file with data of say 10 Employees and the layout of your output?

Second, how many lines of data are you expecting in input?

Regards,