Simple guide availability roster

Hi folks

i am new in this community and learning SharePoint and it's features. my requirement is to create a roster whereas employee have the rotating shift and a dashboard or excel report can be published over email. we are dosing these task based on excel evertime a similar excel is created and more than 4 hours needed to complete the on team roster while there are more than 20 teams and then consolidate the sheet to final submissions.

I heard MS SP can resolve this my calendar item or other features added in SP.