Compare data over time - need to form a list of leavers and joiners on a monthly basis

[lewdow]

Hi

I have 12 sheets (one per month) containing standardised data of employees.

On a commentary page I would like to show leavers and joiners (i.e. they weren't in the previous months list or they are no longer in the list although they were last month).

My first though was a vlookup, but getting this to work so that I just see leavers and joiners and not lots of empty spaces.....hmmm - any ideas guys n girls?

Thanks

lewdow