Dragging cell data down across 1000 workbooks possible?

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!

Originally Posted by alansidman

Are all 1000 workbooks in the same sub folder?
Are there any files in the sub folder that will not get updated?

Explain the manual mechanics in detail of what you do so that we can determine an automated solution that replicates this task.

All 1000 workbooks can be in the same folder, so I will say yes to that question. All 1000 workbooks need to get updated each month and I will explain the process below:

Each month an account reconciliation process is done and the bank statement shows the new interest rate to update on each of the 1000 workbooks. Each workbook has a configured formula to show the balance and interest accrued and by adding the ability to input the new interest rate, it would save me time from opening 1000 workbooks, adding the new interest rate and jotting down the new balance total.

Originally Posted by Richard Buttrey

As Alan intimates you'll need a VBA macro for this.

But a more fundamental question is why are you using 1000 workbooks? From where does the data come, how are they updated and by whom? 1000 different people?
Once all the data was combined into a single workbook could you see new data being added to the single workbook instead?

In other words should our effort be concentrated into getting stuff into a single more easily manageable workbook (and don't assume tnat necessarily means 1000 worksheets in the single wb), or providing something that has to iterte through 1000 workbooks each day?

Hi Richard,

To answer your first points, the reason I have 1000 workbooks is because each workbook belongs to an account that we have records for and the workbook contains the original balance plus an interest calculation that I add in a new interest rate to each month. This increases the balance and I need to get the total accrual for all 1000 accounts each month and show the increase on my balance books. So yes, they are technically 1000 different people. Since all 1000 workbooks contain deposits at different dates, I couldnt just combine all 1000 "people" into one workbook since the deposit amounts are different and the dates as well.

I just need to do this each month as our bank statement that holds all 1000 "people" has a new interest rate to be input for the formula workbook.

To reiterate the reason, I'll paste what I replied with above:
Each month an account reconciliation process is done and the bank statement shows the new interest rate to update on each of the 1000 workbooks. Each workbook has a configured formula to show the balance and interest accrued and by adding the ability to input the new interest rate, it would save me time from opening 1000 workbooks, adding the new interest rate and jotting down the new balance total.