Scanning Barcodes Into Excel - Macros

I am working for a small job shop company that is producing many bespoke products and recently the company has grown up a bit and a shop floor data collection is required in order to have a control over the production process. The company has 14 machines which are operated by 7 operators and this means that each operator is running 2-3 machines at the same time. The best solution for data collection is barcoding into excel. However i need 3 macros (I think) in order to meet my needs. Those macros need to:

1) show what is currently on the machines (who is doing what and when the particular job has started)
Machine
Operator
Part No
Description
Clock In

Note: Description will not be scanned, this can be filled in based on the vlookup from the waiting parts list

2)show what have been done (who did what, on which machine and clock in/out times). Here it is important to mention that sometimes jobs are stopped and taken off the machine and they are put on the machine later on. Sometimes it will be different machine or operator etc)

Part No
Description
Machine
Operator
Clock In
Clock Out
Machine
Operator
Clock In
Clock Out
Machine
Operator
Clock In
Clock Out

3)show what is remaining to machine.

While searching for a solution I have found here a really nice topic which seems to be a good foundation for my needs Scan barcode to excel with date & time stamp in & out.