Creating a past due (aging) report

[jamjentyler]

After looking thru the forum for some time, I have been unable to find a solution that could be adapted to my problem. I am trying to create a past due (aging) report. The data would be pulled from approx 400 worksheets (one for each contract number). Each worksheet is identical, as far as the information locations. The worksheet contains this information:

B1 = Contract Number

Bill Date(colA) Princ(colB) Int(colC) Total (colD) Running Balance (colE)
1/7/09_______$49.21___ $46.08__ $95.29 _____$95.29
2/3/09______ $49.64___ $45.65__ $95.29_____ $190.58
01/00/00____ $ 0.00____ $ 0.00__ $ 0.00_____ $190.58


This billing information is pulled in from another data input worksheet.
The running balance will reflect any payments that have posted to the account. The sheet is set up with 12 rows of data (one for each month), so there are "01/00/00" dates that have not been filled in yet.

I am hoping to be able to do this without having to change anything in these worksheets, as there are so many involved. (Having all formulas needed built into the new worksheet.)

I would like the Past Due (aging) report to be in a new sheet and look something similar to this:

Contract# Current 15-45 days 45-89 days over 90 days
486925__ $0.00__ $95.29___ $95.29____ $0.00


Am I asking the impossible? I only know the basics of Excel and then just enough to be dangerous.

Any advice/help will be greatly appreciated.
JW