I have a workbook with the 1st sheet is a main calendar, the two sheets after are the same calendar, but sorted different.
The first (main) sheet is sorted by date, time, event name. The second sheet should be sorted by event name, date, time.
The third sheet should be sorted by shift, date, event name.
I have a macro running that copies the data from the first sheet to the two consecutive sheets, but I need to find out how to automatically sort the sheets when I enter the data the first time.
I am fairly new and still learning VBA. I would ultimately have a button in the toolbar that will sort on demand.
Please help.

Here is a sample so you can see the data (in general) I'm working with.
sample of calendar.jpg