thank you for your quick reply:
1. The person who will be doing the work is the persons initials in column J , the name eg Haillie is the contact who put in the initial enquiry not the person doing the work. That's why I need the data to copy over to these initials tabs.
2. the completion date will be added into column E of the initial tabs - I need this completion date to populate column M in the workflow tab - yes the file reference will be unique to each job but not every job will have one
3. I was hoping the trigger would be when the initials are added to column J - as this is work for that relevant person
4 The sheet I uploaded is a replica of the one that will be used. I have attached it again
Let me know if you need anything more