Excel 2003 :: Pulling Data From Amortization Schedule To Debt List

I am using Excel 2003 and I created an amortization schedule set up for an debt account. I am trying to pull the "Balance Due" from that schedule into another chart based on the current date (these are on two different sheets in a workbook).

For example, this is my 'Amortization Schedule':

Balance
Due
Interest
Rate
This Month's
Interest
This Month's
Payment

[code]....

And I am trying to pull the "Balance Due" from that schedule to place into this chart on my 'Debts' sheet: (based on the current date)

Name
Starting
Balance
Remaining
Balance
Interest
Rate
Minimum

[code]....

For example, if today were 1/15/13, I would want $3,796.34 from the schedule to go where the "x" is on the chart above. What formula would I use to accomplish this?

Also, on a side note, would there be a formula to have Excel pull the "Payment Date" from the schedule into the "Payoff Date" in the chart based on where the row has a $0 Balance Due?