Use consistent formatting in all the reports.

When you use different formats, as you do, it is not easy to match up information in one report with another report.  For example, use separate columns for start date/time and end date time (some reports used one column 'date start/time - end/time).  In excel format the columns as Date/Time so they can be sorted in date/time order (now, some columns sort as text and some as date time. when sorted as text 10am comes before 2 am and month 10 comes before month 5).  Also some of the date/time columns start with a leading " " space and will not match with the date in another report which doesn't start with a leading " ".

Another example is that in some reports "name' is one column and in others 2 columns ("first name", "last name").  The lack of consistency requires be to do a lot of reformating before I can process and summarize the data.