Pull info between workbooks

Assuming JanDaily.xls is the daily workbook for January, each sheet is named Day1, Day2, etc. and the output cell in your Weekly book is the same as you are reading from the daily:

In Weekly, cell B2 enter:
=C:\Documents and Settings\My Documents\DailyFiles\[JanDaily.xls]Day2!$B$4+[JanDaily.xls]Day3!$B$4+[JanDaily.xls]Day4!$B$4+[JanDaily.xls]Day5!$B$4+[JanDaily.xls]Day6!$B$4+[JanDaily.xls]Day7!$B$4+[JanDaily.xls]Day8!$B$4

note: The FULL path is required at the beginning of the formula, the file name is enclosed in braces [ ] , the sheet tab is followed by an exclamation point ! and the cell reference is made fixed by the inclusion of $

also note the Daily file does not need to be open to update the Weekly file.

HTH

If you are still seeing the formula in the cell after you press ENTER, I think it is treating the formula as a text entry. Verify there is not an apostrophe ( ' ) preceding the entry (check the formula bar at the top of the sheet).

And of course you need your formula to point to the exact location of YOUR file, my formula was an example only!

Good Luck