Hello,

I have a file with one sheet that summarizes hours worked on each project in each week. Each of the other sheets has daily hours worked on each project for each two week period and has a column that sums the hours for each project for that week. I would be grateful if anyone can suggest a function(s) that I can use to have the first sheet automatically pull the correct # from the corresponding sheet, by referencing the project code and the date value in the correct row and column?

Each sheets contain two weeks of hours, so I have added the weekly total for each. Not sure how to reference the right sheet if the week does not match the sheet name (as it will not for every other week).

Thanks!

Jon W.