Need VB macro to link cells

Howdy all. Using Excel 2003.

So I've got 2 workbooks that I utilize for tracking my activities at work and submitting my weekly activities to my supervisor. The 2nd (EOW Reports) is a standard report form given out to all employess to report their activity at the end of the week. The first is a daily activity log that I created to allow me to record my activities in a given day. I'm looking for a way to auto populate fields in the EOW reports workbook from multiple worksheets in the DAILY LOG workbook. Here is a summary:

2 Workbooks:

1) Daily Activity Log - tracks my activity at work and gives me the total amounts of claims I've processed in each of our 3 claim categories. It also keeps track of my hours for the day depending on when I sign in.

2) End of Week Reports - gives summaries of an entire week rather than just a day. I need to find a macro that will auto link a cell in this worksheet to one in a Daily Activity Log Worksheet. I know I can go in and link everything manullay but that will take FOREVER. I'm sure there is a way to write a macro for this I'm just at a loss as where to even begin.

Attached are samples of both workbooks. Man if someone can help me with this you will have a new best friend.

For example: I need the following cells in the EOW Workbook ("1-6" Worksheet) to be linked to the following cells in the DAILY LOG Workbook (Worksheets "Jan-2", "Jan-3", "Jan-4", "Jan-5", "Jan-6")

EOW CELLS = DAILY ACTIVITY CELLS
E4 = B4 ("Jan-2")
E6 = B4 ("Jan-3")
E8 = B4 ("Jan-4")
E10 = B4 ("Jan-5")
E12 = B4 ("Jan-6")

Following this logic for the same cells the next worksheet in EOW Workbook would be the "1-13" worksheet. It would need to look like:
E4 = B4 ("Jan-9")
E6 = B4 ("Jan-10")
E8 = B4 ("Jan-11")
E10 = B4 ("Jan-12")
E12 = B4 ("Jan-13")


This pattern would repeat itself for F4, F6, etc. and D5, D7, etc. except the corresponding cell in the DAILY LOG tabs would be B6 and B5 respectively.

Another example is:
EOW CELLS = DAILY ACTIVITY CELLS
H4 = D3 ("1-2")
H6 = D3 ("1-3")
H8 = D3 ("1-4")
H10 = D3 ("1-5")
H12 = D3 ("1-6")

Even though there are 8-9 different cell combinations I'm pretty sure a single macro could work for all of them. I could go in and input them manulally but that would take forecer. I essentially need a macro that will auto link 5 cells in the EOW workbook (contained on the same worksheet) to 5 cells in the DAILY LOG workbook (contained on 5 different worksheets).

There may be a much easier way to go about doing this so feel free to shout out any suggestions even if they aren't exactly what I'm looking for. We have to turn in the EOW worksheets at the end of every week and I would like mine to auto populate from my daily activity logs.

Thinking outside the box, is there a way if I enter one in manually that Excel's autofill would understand what I want it to do? I doubt it but was trying to think outside the box.
MANY thanks for any help.

Cheers,
Brad



DAILY LOG.xlsEOW (End of Week Reports).xls