Copy cells on a specified date

[oitisme]

Hey Collective,

I'm trying to create a weekly report and I want the data to update the report autonomously every week from the TOTAL row to the report on a specified date. Is this possible to do?
Data

Task List	Investigated	Engaged	Completed
Task 3		1
Task 1	1
Task 2			1
Task 4	1
Task 5		1
Total	2	2	1

<tbody>
</tbody>

Weekly Report

Progress	Investigated	Engaged	Complete
Last Week	1	1	0
This Week	2	2	1
Variance:	1	1	1

<tbody>
</tbody>

 

[oldbrewer]

task	inv	eng	comp				TODAY = JUNE 2 2017
T1	01/04/2017	09/04/2017	15/04/2017
T2	05/04/2017	13/04/2017	25/04/2017
T3	09/04/2017	17/04/2017	05/05/2017
T4	13/04/2017	21/04/2017	15/05/2017
T5	17/04/2017	25/04/2017	25/05/2017
T6	21/04/2017	29/04/2017
T7	25/04/2017	03/05/2017
T8	29/04/2017
T9	03/05/2017
T10	01/05/2017
							inv	eng	comp
					01/04/2017	07/04/2017	0	0	0
					08/04/2017	14/04/2017	0	0	0
					15/04/2017	21/04/2017	0	0	1
					22/04/2017	28/04/2017	0	0	1
					29/04/2017	05/05/2017	3	2	1
					06/05/2017	12/05/2017	0	0	0
					13/05/2017	19/05/2017	0	0	1
					20/05/2017	26/05/2017	0	0	1
					27/05/2017	02/06/2017	0	0	0
					03/06/2017	09/06/2017	0	0	0
					10/06/2017	16/06/2017	0	0	0
					17/06/2017	23/06/2017	0	0	0
					24/06/2017	30/06/2017	0	0	0
		this sort of approach shows how many tasks are at each stage
		and the table updates as tasks move to next status

<colgroup><col><col span="3"><col><col span="2"><col span="5"></colgroup><tbody>
</tbody>