Copying new names from a master tab onto each tab for every month

[jennys83]

Hi,

Can someone help please?!

I have a holiday/sickness tracker spreadsheet which I am trying to revamp.

It currently is all done manually that if there is a new starter or someone has left, each tab has to be updated with any new names etc.

I want to write a macro that will look at my master tab with all names etc. on (which I have just created and this will be the one to add any new ones on) to then copy onto each month's tab and then sort it.

I've done a similar macro before when if it has a certain keyword it copies into a relevant tab, but I want it to not have a keyword and just wait until the 3rd column has been filled in and then copy across.

I hope this makes sense.

If someone could help, that would be great!

Thank you

Jenny

[arlu1201]

It will be good if you explain with the help of a sample file.

[jennys83]

Here is my file.

The 1st tab is where will be my master list of names which will be added to when we have new starters.

I want it to automaticlaly add these new names & job titles on each month's tab & then sort in alphabetical order within the Contract status i.e. Permanent, Contractor, EPAM.

If there's also a way of removing any deleted ones that would be great too!

Or I'm wondering if it'll be easier just to get the cells from each month to look at the master via a vlookup maybe??

Thank you

Jenny