Automatically copy newly inserted row(s) from one worksheet to another

[Lao]

Hi everyone!

I searched the forum for this, but either it's not here (doubt it), either I wasn't able to find it.

Problem looks pretty simple, but I can't find the solution.

One workbook, 2-3 sheets in it. One of the sheets must be the master sheet (called TOTAL), which gadders all new rows put in all of the other sheets.
Every colleague of mine has his own sheet to put the info in, daily. Basically, new info means new row in a person's sheet.
The cells from the first column are always unique in all the sheets.

I want the TOTAL sheet to increase daily with the rows added in the other sheets by my colleagues.

Small example: if everyone of us puts 5 new rows in his personal sheet and we are 3 persons, the master sheet increases automatically with 15 rows. I repeat, if it's important: ONLY the cells from the first row of every sheet is unique.

Thanks in advance!
Lao Mayer

Fetea.xlsx

[hemesh]

Hello Lao
In sheet Total in A2 Copy Paste below formula then hold control and shift together then hit enter to make it array formula then drag down and drag

Please Login or Register  to view this content.

is this what you are looking for.

[micope21]

Hi

See the file!!

It a VBA automatic!!

Once person type in their detail, Once get to column L number?? It will automatic go straight to Total Sheet!!

You can have many colleague on each sheet??

Is this what you look for??

Regard
micope21

[Lao]

Thank you both for your effort. I really appreciate it. I'll use the macro from @micope21, because I don't want to go back and check every week if the Total worksheet has enough rows with formula in it and it does exactly what I was looking for.

Thank you both, again.

Lao Mayer

[hemesh]

Thanks for the feedback lao.

[ericmday]

Can there be a line of code here that will automatically update the line if data from one of the sheets, "John" for example, is altered or deleted?

Additionally, how would it be possible to have an additional column in the "Total" page reference the sheet the data was copied from?

Looking forward to your help!