How do i create a macro to save data from a Shift Recap to a summarized on a separate sheet at timed intervals

[PAULBURKE]

I have a shift recap that generates downtime and the causes for a piece of equipment. At the end of each shift a macro is set to save the entire recap, clear the form so that the next shift doesn't have to do it manually, and sends the recap to all of management. I now need to find a way to save all the entries of each shift to a master sheet before the macro clears the form. Then I need to summarize all the data for a 24 hr. period, weekly, and monthly so that the data can be graphed and acted upon.