Linking Sage and Excel to prepare management accounts - book recommendation?


I currently use Excel to prepare management accounts for one of my clients but I am still manually inputting figures into Excel and it is very time consuming. I am aware that there is an integration link between Sage and Excel and then its possible to set up macros to do some tasks, but despite my general proficiency in Excel this is beyond me.

It gets complicated because we use the department function in Sage to report on 21 different departments which then combine differently in the management accounts. Does anyone know of a good book that would help me set up some automation to what is currently a very time consuming process each month.