Code to manage records in multiple sheets

Hello! How are you ?
Since this is the first time I appologise
in advance if anything goes wrong.

My message as below
-----------------------------------
I have an attachment of the excel file
-----------------------------------------

I have my sheets from West-M1 to GUJ-3.
All the sheets having different numbers in column A.
None of them repeated in any of the sheets.
For just demo purpose the actual data is not represented.
Also all the sheets have the data but here the data is reflected
in the first four sheets only. However the actual effect of the
code required in throughout all the mentioned sheets.

My requirement mentioned in Code1 and Code2 sheet.

Thank you
GeorgeT

I have received your reply and thanks xladept.
I will check the code perfectly with my associated
co-employee and get back to you tomrw.

Have a nice day.

Thanks
GeorgeT

Hello xladept

I checked the code and is working fine.
One point wanted to know.
When run code2 first then code1 doesnot work.
But when run code1 first then works.

Any method I should take care to operate. Just let me know.
Also in future if I want to know anything or make changes in the existing code
then how do you directly link to you since you have developed it.

Thanks
GeorgeT