Creating Data Storing Sheet by adding deleted rows

[Tet Htut Naing]

Hi Everybody,
I am just a novice in excel subject.
Now, I have a big question on data storing. There are 6 Sheets for data entry. Each sheets has unique Name order by using =Sheet1!A4. This excel book is meant to make data of Staff in my organization, a NGO. 200 Staff data are entered into those 6 Sheets.
The situation is on resigning and new coming of the staff. To store the data, a new sheet (Namely, Staff Background Data Sheet)is created with the unique staff name and order with Sheet 1.
What I want to know is a macro to run on deletion of a row, then
1. collect the selected data from those 6 data Sheets
2. match with the staff name in Staff Background data (if needed)
3. Add the collected data.

I have a macro for deleting a row in all 6 Sheets simultaneously.

IF you have possible answer, please help me. Thanks all in advance.
Htut
I tag Mr.mikerickson, for this, if I bothered Mr. Mikerickson, I appologize in advance.

 

[oldbrewer]

is there a single row for each staff name on all 6 sheets ?

 

[Tet Htut Naing]

is there a single row for each staff name on all 6 sheets ?

Yes, Of course. In all Sheets, one staff is one row.