You should probably elaborate a bit on what exactly you need, because your post is not that specific and the attached file doesn't help that much either.
If what you need is to populate column C of sheet "Sheet1" with the sum of values in column E of sheet "Data", based on the information of columns A and B of sheet "Sheet1" and on the Week selected in the yellow cell, try this in cell C5: