Macro to copy several items based on several conditions and paste on specific cells of another workbook

[gxa08]

Hi there,

I'm need of some help please, as I'm currently having to track and compile all the data mentioned below manually.

Here is the situation:

I have a workbook with several sheets. Each sheet contains a weeks worth of punch times for several employees. The data on each sheet is always formatted the same. This is what it contains:

Div	Dept	Manager	Employee	ID	Punch Type	Day	Date	Time
2	9999	PETERS, JOHN	SMITH, JOE	1234	Clock In	Sat	06/09/2018	13:23
2	9999	PETERS, JOHN	SMITH, JOE	1234	Clock Out	Sat	06/09/2018	19:11
2	9999	JONES, JAMES	JOHNSON, PAUL	2345	Clock In	Sat	06/09/2018	06:29
2	9999	JONES, JAMES	JOHNSON, PAUL	2345	Going to Meal	Sat	06/09/2018	12:33
2	9999	JONES, JAMES	JOHNSON, PAUL	2345	Back From Meal	Sat	06/09/2018	13:31
2	9999	JONES, JAMES	JOHNSON, PAUL	2345	Clock Out	Sat	06/09/2018	15:32
2	9999	PETERS, JOHN	SMITH, JOE	1234	Clock In	Sun	06/10/2018	11:30
2	9999	PETERS, JOHN	SMITH, JOE	1234	Going to Meal	Sun	06/10/2018	17:26
2	9999	PETERS, JOHN	SMITH, JOE	1234	Back From Meal	Sun	06/10/2018	18:21
2	9999	PETERS, JOHN	SMITH, JOE	1234	Clock Out	Sun	06/10/2018	20:34
2	9999	SMITH, AMBER	GARCIA, JOSE	3456	Clock In	Sun	06/10/2018	11:34
2	9999	SMITH, AMBER	GARCIA, JOSE	3456	Going to Meal	Sun	06/10/2018	14:05
2	9999	SMITH, AMBER	GARCIA, JOSE	3456	Back From Meal	Sun	06/10/2018	15:06
2	9999	SMITH, AMBER	GARCIA, JOSE	3456	Clock Out	Sun	06/10/2018	20:28
2	9999	PETERS, JOHN	PAUL, ROBERT	4567	Clock In	Sun	06/10/2018	11:27
2	9999	PETERS, JOHN	PAUL, ROBERT	4567	Going to Meal	Sun	06/10/2018	16:05
2	9999	PETERS, JOHN	PAUL, ROBERT	4567	Back From Meal	Sun	06/10/2018	17:05
2	9999	PETERS, JOHN	PAUL, ROBERT	4567	Clock Out	Sun	06/10/2018	20:27

<tbody>
</tbody>

Ideally I would like to have the macro look for each name on the employee column, the day, date, and punch type, then paste the clock in, meals, and clock out onto another workbook on specific cells. This is what the other workbook looks like:

					Schedule
Day of Week	Date	Clock In	Lunch Break Taken	Clock Out	Scheduled Time In	Lunch Break	Scheduled Time Out
Saturday	6/9/2018				6:30:00	1:00:00	15:30:00
Sunday	6/10/2018
Monday	6/11/2018
Tuesday	6/12/2018				6:30:00	1:00:00	15:30:00
Wednesday	6/13/2018				6:30:00	1:00:00	15:30:00
Thursday	6/14/2018				6:30:00	1:00:00	15:30:00
Friday	6/15/2018				6:30:00	1:00:00	15:30:00

<tbody>
</tbody>

On this second workbook, I have a sheet for each employee. Each sheet contains the data above for a whole quarter. From here, I have formulas that give me the difference between the clock in, lunch break, clock out versus what the employee is schedule.

Sorry, I know is a lot and probably super confusing. Any thoughts, ideas, suggestions will be greatly appreciated.