Automation

hello ,

i used to make a report on excel which exceed more than two hours every day i will mention the report in breif

i have a big report which is a fixed report that didnot change and i have files with row data which i took the values from those files and update this values in the big report , this values are numbers only and if any record appears for the first time in the files i took it and add it to the big one since this record is not included in it also their is graphs

please tell me if their is any option to automate this report by any way