creating a calendar with auto-update functions

Hi,
I have been tasked with creating an excel ‘tool’ to manage the HR of a company. There are many people on many shifts each day, and it is becoming hard to keep track of where people are when.
I have created the layout of the workbook, as I desire it, but am stuck on getting the formulas right, having only just started experimenting with various Excel formulas (IF,LOOKUP etc) and have never used macros or VBA.
Basically I wish to automatically update cells E2 and E3 on tab ‘Joe Bloggs’ based on the text in today’s date cell in the calendar on that same tab. The index pages will then be updated. The text in the calendar cell will simply display the employee’s location.
The whole workbook will be updated by several different users in various locations, and will be located on a server for this purpose.
I have read various other posts regarding calendars/auto-update, but none seem to be the right fit.
Any help would be hugely appreciated. Also, please let me know if I am going about this the wrong way.
Cheers.