I am using Excel 2003 and I am wondering if there is a way to automatically
update an Excel workbook from another workbook. I have example files, and
some comments within that explain this better, however I can not figure out
how to insert the example files into this posting. In a nutshell I have one
workbook that gets updated every day and has the same name day after day. I
want the data from that work book to automatically populate another work book
every day (titled "to be populated") based on the date on the populated work
book titled "updated data". If what I want to do can not be done, are the
other suggestions or methods to achieve this?

"updated data" work book
A1 = Date A2 =today()
B1 = A B2 = 3
C1 = B C2 = 4

"to be updated" work book
A1 = Date A2 = 9/17/06 A3 = 9/18/06 A4=9/19/06
B1 = A B2 = 5 B3 = Populated from updated data book cell b2
B4=Poulated the next day from b2
C1 = B C2 = 2 C3 = Poluated from updated data book cell C2
C4 = Populated the next day from cell C2

Thanks for any insight!!! :)