Cross checking between spreadsheets with multiple worksheets

[Sirod]

Hello,

I need to compare data on two separate spreadsheets that are organized differently. I have a master spreadsheet that lists employees and related information (Region, department, title, etc.). All employees are listed on a single worksheet. I have a separate spreadsheet that has similar information on it, however this spreadsheet lists the employees on separate worksheets for each different region.

The master list is more recent. I need to compare the master list against the older separated worksheet to determine:

1. If there are any new employees
2. If any employees have left
3. If any employees have changed title.

I'm not sure what formula I need to accomplish this. Please no VBA as I'm not proficient at it.

Thanks.

A sample of the spreadsheet data is as follows:

Region	Employee Name	Department	Title
North	John Smith	Sporting goods	Supervisor, Customer Service
North	Jane Doe	Appliances	Sales Associate
East	Bob Smith	Grocery	Sales Associate
West	Mary Johns	Grocery	Supervisor, Customer Service