I have asked before but I'm afraid my posts were unclear.

I have a "Summary" Worksheet and 4 "Weekly" Worksheets. I need to link only
two cells from the "Weekly" sheets to the "Summary" sheet. i.e.

"Worksheet "Week One" sends data "Names" from Col E10:E39 to "Summary" sheet
Col C8:C37 along with sending data "Points" in "Week One" sheet Col C10:C39
to Col F8:F37 in "Summary" sheet.

"Worksheet "Week Two" sends data "Names" from Col E10:E39 to "Summary" sheet
Col C8:C37 along with sending data "Points" in "Week Two" sheet Col C10:C39
to Col G8:G37 in "Summary" sheet.

"Worksheet "Week Three" sends data "Names" from Col E10:E39 to "Summary"
sheet Col C8:C37 along with sending data "Points" in "Week Three" sheet Col
C10:C39 to Col H8:H37 in "Summary" sheet.

Worksheet "Week Four" sends data "Names" from Col E10:E39 to "Summary" sheet
Col C8:C37 along with sending data "Points" in "Week Four" sheet Col C10:C39
to Col I8:I37 in "Summary" sheet.

All "Points" (Col C10) in "Weekly" sheets are Formula driven.

I need to maintain the relationship between the Names and Points in all 5
Worksheets

Perhaps this is a bit clearer.

Any help?

Bob