Macro to Copy Data from One Sheet onto Multiple Sheets

Hi,

I am wondering if it is possible to create a macro to Look at a Sheet and Copy to Existing Sheets by Initials? I have attached a copy of my Workbook. The first sheet is called "Synchrono" this is imported from a different Workbook, what I would like to do is have it automatically Add/Delete to the appropriate Worksheets by the "Designers" Initials.

The final sheet is "Combined", I have created a "rough" macro using previous threads to combine all of the Designers into one sheet. If possible would like to have this all happen all together.

Unfortunately, I have to share this document so mutliple users can update at the same time. I know macros don't work with "shared" workbooks...so wondering if you had any ideas on this as well? For now I am going to designate a time where I will go in and unshare and run the update macros.

Hope this makes sense...any help is appreciated.

Thank you,
Sandi