I have a tedious accounting dilemma

Each month (until I find a better accounting system) I must open about 1000 workbooks individually to drag down one cell from the previous months workbook (its an ongoing monthly task with 1000 workbooks). I am looking for a way to make this easier since this just one aspect of what I need to accomplish. Ideally I would like to see if there was a way to update a workbook, take data from a cell and move it another workbook to make a list of 1000 updates/changes.

My company uses MS Office 2010.

I hope my dilemma made a little sense!