Good afternoon,

I am working with a series of workbooks (nine in all) and some of the data in each of them needs to be exported to another workbook in order to produce invoices and KPI information.

My problem lies in the fact that each of the workbooks is in use daily and, at the end of each day, is saved into a central file (luckily the target workbook resides, or can, in the same central file).

I have searched "Excel 2010 Inside Out" and "Learn Excel 2011 for Mac" as well as scouring the various forums and boards without success. Can anyone point me in the direction of a resource that would be able to help me.

Thanks

Uncle H