I have hit a wall trying to figure out the most effiecient way to automate
the recording of historical data (interest rates in this case). Say I have
15 different lenders, each of which has a different interest rate, and each
rate changes at a unique time, and under unique conditions. I have each
lender set up on its own sheet to calculate the current rate, no problem
there. But I am trying to build a single "historical rates' page that will
list each lender across the top, and each day down column A. How can I best
automate the process of recording each days interest rate in the historical
rates table (vs having to manually update the table whenever the file is
opened). I keep running into issues revolving around the various dates
associated with each lender.

Thanks in advance