Automate Reports so they can be updated just by bringing in new data

I have data in excel and i have manually created reports. I would like to be able to just insert a new data set and have the reports i have made be generated so i don't have to recreate them every time. I want to be able to only use the incidents data tab and the payroll statistics in the raw form and have the reports generated. This should be something that as I paste in the new data each month the reports update and build the month. The one part i have not been able to figure out yet is how to do everything by taking into account hrs. I want to use the payroll statistics to be able to do this. I has hrs by the needed categories. I also need what i have done at a company level created for each city as a separate report in the same fashion. The better presentation of the reports the better as well.