Change one or multiple cell values in a row and reflect the same in diffenent sheets in the same workbook

[dss28]

I have three sheets (Sheet1, Sheet2 and Sheet3). The data in these three sheets is identical upto 5 columns. the data in the first row is same as the data in first row of 2nd and 3 rd sheet and so on . That means all row and columns are identical upto 5th column.
The data in these sheets differ in column 6 onwards.
I can search a row using listbox in one sheet, edit, update etc.
So if I edit any data in Sheet1, I want to update the same in the other two sheets as will for the first 5 columns.
I dont want to give three listboxes correspoding to three sheets to search, edit, update the data one by one in three sheets. as the userform gets bigger
Is there any simpler way to do this.

Book1
	A	B	C	D	E	F	G	H
1	SrNo	Heading 1	Heading 2	Heading 3	Heading 4	Heading 5	Heading 6	Heading 7
2	1	name1	code1	mobile1	address1
3	2	name2	code2	mobile2	address2
4	3	name3	code3	mobile3	address3
5	4	name4	code4	mobile4	address4
6	5	name5	code5	mobile5	address5
7	6	name6	code6	mobile6	address6
8	7	name7	code7	mobile7	address7
9	8	name8	code8	mobile8	address8
10	9	name9	code9	mobile9	address9
11	10	name10	code10	mobile10	address10
12	11	name11	code11	mobile11	address11
13	12	name12	code12	mobile12	address12
14	13	name13	code13	mobile13	address13
15	14	name14	code14	mobile14	address14
16	15	name15	code15	mobile15	address15
Sheet3

Book1
	A	B	C	D	E	F	G	H	I
1	SrNo	Heading 1	Heading 2	Heading 3	Heading 4	Heading 5	Heading 6	Heading 7	Heading 8
2	1	name1	code1	mobile1	address1
3	2	name2	code2	mobile2	address2
4	3	name3	code3	mobile3	address3
5	4	name4	code4	mobile4	address4
6	5	name5	code5	mobile5	address5
7	6	name6	code6	mobile6	address6
8	7	name7	code7	mobile7	address7
9	8	name8	code8	mobile8	address8
10	9	name9	code9	mobile9	address9
11	10	name10	code10	mobile10	address10
12	11	name11	code11	mobile11	address11
13	12	name12	code12	mobile12	address12
14	13	name13	code13	mobile13	address13
15	14	name14	code14	mobile14	address14
16	15	name15	code15	mobile15	address15
17
Sheet2

Book1
	A	B	C	D	E
1	SrNo	Heading 1	Heading 2	Heading 3	Heading 4
2	1	name1	code1	mobile1	address1
3	2	name2	code2	mobile2	address2
4	3	name3	code3	mobile3	address3
5	4	name4	code4	mobile4	address4
6	5	name5	code5	mobile5	address5
7	6	name6	code6	mobile6	address6
8	7	name7	code7	mobile7	address7
9	8	name8	code8	mobile8	address8
10	9	name9	code9	mobile9	address9
11	10	name10	code10	mobile10	address10
12	11	name11	code11	mobile11	address11
13	12	name12	code12	mobile12	address12
14	13	name13	code13	mobile13	address13
15	14	name14	code14	mobile14	address14
16	15	name15	code15	mobile15	address15
Sheet1

 

[JEC]

If you just want to update your rows in the first 5 columns, this might be enough.
You could put this at the end of your macro

Sub jec()
 Sheets(2).Range("A1:E1000").Value = Sheets(1).Range("A1:E1000").Value
 Sheets(3).Range("A1:E1000").Value = Sheets(1).Range("A1:E1000").Value
End Sub

 

[dss28]

will it perform the following :
if i want to update data in C5 cell using a list box search/ edit function where i recall these 5 columns data in a userform which is linked to sheet 1 and if i click update button it will change the C5 value in sheet2 and 3 simulatneously?
i may have data in more than 1000 rows and growing everyday

 

[dss28]

will it perform the following :
if i want to update data in C5 cell using a list box search/ edit function where i recall these 5 columns data in a userform which is linked to sheet 1 and if i click update button it will change the C5 value in sheet2 and 3 simulatneously?
i may have data in more than 1000 rows and growing everyday

If you just want to update your rows in the first 5 columns, this might be enough.
You could put this at the end of your macro

Sub jec()
 Sheets(2).Range("A1:E1000").Value = Sheets(1).Range("A1:E1000").Value
 Sheets(3).Range("A1:E1000").Value = Sheets(1).Range("A1:E1000").Value
End Sub

 

[JEC]

It's hard to say without knowing your exact way of working.
If you update a row in sheet 1 and just put these lines of code at the end of your userform macro, you will update columns 1 to 5 in sheet2 and sheet3.