I also have another table which consists of list of people for September month who are working on shifts.
Why for only the month of September?
You need to start with a data model (set of tables and relationships) that work for what you want to do. A typical set up is to start with a table of employees. Then add a related table of shifts where you then schedule employees to work a particular shift or series of shifts (over a specified number of days) by creating records in a third table that links a record in the employees table to a record in the shifts table.
Employees::__pkEmployeeID = Shift_Assignments::_fkEmployeeID
Shifts::__pkShiftsID = Shift_Assignments::_fkShiftsID
There are many different interface options possible for assigning employees to shifts using this basic data model.Which will work best for you will depend on how you need to manage shift assignments. One option is to place a portal to Shift_Assignments on the Employees layout to list and select Shifts records for each employee by creating records in that portal linked to their assigned shift. Fields from Shifts can be included in the Portal to show additional info about each selected Shift record and the _fkShiftsID field can be set up with a value list for selecting Shifts records by their ID field.
Once you have assigned employees to shifts, you can then set up your dashboard with an unstored calculation field that uses Get ( CurrentDate ) to compute the current date that matches to Shift_Assignments, or possibly shifts to list all employees working on that day and in what shift. (The details can depend on what data you choose to put in the shifts table.)
For an explanation of the notation that I am using, see the first post of: Common Forum Relationship and Field Notations Explained