Time & Attendance Excel Worksheet

Hi There

We have a Fingerprint reader for our staff Time & Attendance. Attached the standard report from the device - untouched


Now in this report, it give a daily breakdown of the Employee Check IN, Breaks and Checkout
Check In - meaning when the user start work
Breaks - Off duty for tea or lunch breaks
Check out- Meaning when user finishes work

Now what I want, a VB marco script on the attachment below:


On the worksheet open, to prompt me, to upload the Standard_report (from the device excel worksheet)
Refer to: Att.log report TAB
Create each new tab with the Employee Number
And fill in the working times (as shown in example for Employee 7 and 23)

Thats it

Could you kindly do this formula VB scrip