I have multiple Excel spreadsheets that all have similar data but not exactly the same. I am looking for a way to have the least amount of manual data entry.
All the Excel spreadsheets are filled out manually monthly by several leaders and takes a considerable amount of time. Most of the time the data is than used to create PowerPoints. Also, some of the spreadsheets track new initiatives and results so its not just numbers are all the time.
I am looking for a way to simplify these tasks. Any suggestions?