Dynamic Table
 

I have a worksheet named Dailies in which data is entered every day. I have
another worksheet in which I want to create a summary table that updates at
the end of each new week. This means the cells in my summary table would be
sums of cells from my Dailies worksheet. Also, the cells that I am adding up
for my summary table are not adjacent in my Dailies worksheet. How do I get
Excel to dynamically add the right cells and automatically update every week?
Is this even possible?