How to lock or show the data including date that user input?

[haha97]

Hi. I want to create a weekly project tracking.
This is the step:
1. User enter the required date to fill in the data
2. The formula will automatically display the required week and Monday date
3. User key in project, start, end, status and manager

The problem is:
Assume after filling the data from previous step, I want to fill in another data again into a different date. So, user can follow step 1. But, the problem is, it just update the date only, excluding all the data and the actual date. Is there a way where the data that we entered previously can be locked together with the date that we typed during step 1. Also, if can, I want the latest date to be shown at the right side and previous date at the left side. I already attached the excel file for your reference.

Thank you

project_tracker.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1
2	Date start (Mon)	3/4/2022
3
4	Week 14					Week 15					Week 16
5	28/3/2022					4/4/2022					11/4/2022
6	Project	start	end	status	manager	Project	start	end	status	manager	Project	start	end	status	manager
7	A	1/3/2022	1/6/2022	in progress	M1
8	B	1/1/2022	1/10/2022	on hold	M2
9	C	1/3/2022	2/6/2022	in progress	M3
Sheet1

Cell Formulas
Range	Formula
A4,K4,F4	A4	=CONCATENATE("Week ",WEEKNUM(A5,2))
A5	A5	=B2-WEEKDAY(B2,3)
F5,K5	F5	=A5+7