Do some data entry

I have some work, in an Excel spreadsheet. Create a macro in Google sheets. Will have main workbook with all jobs. Jobs assigned to employees and each employee to have their own sheet that they can edit, which in turn will also update the data in the main workbook. When new jobs are assigned I need would like a separate sheet that I can add the data. Then run a macro that will scan the data added and any jobs that are not in the master workbook will be added. Any job that is already part of the master workbook will be ignored. Once new jobs are added it will also preepopulate the individual employee sheet.