VBA to update 2 Sheets from Data entered in 1 sheet

[Sufiyan97]

Sheet 1

Book11
	A	B	C	D	E	F	G
1	Client Name	Code	Company	tax Return	Remark	Status	Sent to
2	Abc	123	Xyz	1099		Working	Mr A
3
4
5
6
7
8
Sheet1

In sheet 2 & 3 I want below fields to be updated from sheet 1 when I run the first code

Sheet2

Client Name = From sheet1
Code = From sheet1
Date = Current Date
Start = Current Time

Book11
	A	B	C	D	E	F	G	H	I
1	Client Name	Code	Date	Billing code	Start	End	Total	Comment
2
3
4
Sheet2

Sheet3
Date = Current Date
Client = From sheet1
Start time = Start from sheet 2

Book11
	A	B	C	D	E	F	G
1	Date	Client	Start time	End Time	Type of work	Description
2
3
4
5
Sheet3

With 2nd code I want below fields updated

Sheet1
Remark = If possible I want a popup userform to enter remark

Sheet2

End = Current Time
Total = End - Start
Comment = Remark from sheet1

Sheet3
End Time = End from Sheet2
Description = Remark from sheet1

 

[Sparcot]

In sheet 2 & 3 I want below fields to be updated from sheet 1 when I run the first code

Hello. Only for 1 client? Or it will be a list? If a list - every time will be a new list? Or you will add more clients row by row in sheet 1?

 

[Sufiyan97]

Hello. Only for 1 client? Or it will be a list? If a list - every time will be a new list? Or you will add more clients row by row in sheet 1?

I will add more clients row by row in sheet 1 after completing previous one.