Macro add new record without replacing or affecting old record

[Kenji]

Dear Admin,

I got one new idea on my tedious task but I can't figure out how to do that, I really hope that you all can give me some suggestions. Thanks

I got one excel template:-

WorkSheet(Template):
A1 B1
1 Student Exam Paper Preparation
2 Student Name list
3 Student Name tag design
4 Mother's day event

WorkSheet(Data Entry1):
A1 B1
1 Student Exam Paper Preparation
2 Student Name list
3 Student Name tag design
4 Mother's day event

I use to key in the new project in Worksheet(Template) like I might add one more 5 Father's day event. On and Off I got new project add in.
So my teachers will key in their time spend according to the template given in the (Data Entry) worksheet.

In order to make this 2/more worksheets tally, I will use copy paste function(record macro). BUT, once they sort the sequence of the template in their Data Entry worksheets.
I hardly to use macro blindly copy paste.

QUestion:

1. How can I use macro to help me, whenever I got add 3/ more new projects. The macro smart enough to compare with those existing worksheet, just add those NEW projects into their template at bottom, so that wont affect their existing sorting.


Please advice, the example given is under few worksheets in ONE workbook. Actually we work on different workBOOK, so very hard to use copy paste already. Please help Thanks