Update One Workbook From Another Based On Unique Criteria

I have two workbooks. I use excel 2003

I need to update the master workbook with data from the invoices workbook using the following criteria.

In the master workbook column C has unique job numbers.
In the invoice workbook column F has unique job numbers.
Both worksheets are the first worksheet in both workbooks.

If the job number in the invoice workbook is already in the master workbook do nothing.

If the job number is in the master workbook but not the invoice workbook then delete the entire row from the master workbook.

If the job number is not in the master workbook add it to the master workbook.

To complicate matters the master workbook is shared. It is my understanding that shared workbooks can't contain the macros needed ? It would be preferable that the master sheet had them but if not ...