I have 4 investment properties, each has an amortizing loan. I put an amortization schedule on each of 4 tabs in my workbook. On another tab I in the same workbook I have created a financial statement. In the financial statement I use a reference to a data tab where the current principal balance of each loan is inserted. I update the data tab manually on a monthly basis by changing the reference to the cell in the loan amoritzation tabs matching the current month (i.e., the first day of each month). Is there a formula that I can insert in my data tab cells that will automatically change the cell cross-references in the amortization tabs (on the first date of each calendar month), so that the financial statement updates automatically at the beginning of each month to accurately reflect the current mortgage loan balances?
