linking a series of cells from one sheet to another.

Thank you Dennis! That worked really well.

The only thing (as you can see in the attached) is that Mar 30-Apr 6 on the Summary sheet for some reason does not seem to work. I assume it is a problem in the sheet of this name but I have not been able to find the cause. Any ideas?

Thanks a bunch!