Not a Excel guru,
This is easier than you think.
First: In the workbook that you want the "updated data" to show up in, Open
this worksheet. Open the workbook that the data is coming from.
What I like to do is size both worksheet so both are open and viewable,
preferable side X side, or one in front of the other.
Second: select the cell that you want the data to update to, type "="
without the quotes. Now on the worksheet that has the data, or will have the
data. Selcet that cell.
The "updated data" sheet cell show look like "=sourcesheet!$C2", without
quotes.
- where sourcesheet is name of workbook and sheet name or number.
- $ will lock the column, so it will not chage if you copy the cell down
on this worksheet.
Care must be taken, because if workbooks are moved, renamed or deleted. The
worksheet looking for the data will give you all kinds of errors.
I hope this helps and good luck.

"not an excel guru" wrote:

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!!! :)