Need to copy all data for each week and compile to one sheet for year to date data.

Please help!

is there an equation to collect data input on a daily basis for each week and put it in one worksheet or workbook?


i have each sheet representing week 1 through week 52 for the entire year.

i would like to collect the hours for each task that each employee has done year to date.

Please see sheet "YTD" sheet for desire output.

Thank you in advance for your help.