I have say 12 worksheets for 12 months

each worksheet has say 4 columns "Activity"(in col A), "Start"(in col b),
"Finish"(in col c), "Status"(in col d)
each worksheet has a definite number of rows for data entry and cant extent
beyond these values(ex:A7 to A39 for "activity" similarly b7 to b39 for
"start"...)


I want to have a summary sheet with the same 4 columns "Activity"(col A),
"Start"(col b), "Finish"(col c), "Status"(col d)

I have 2 questions

1) whenever a data entry is made in any of the 12 worksheets (between rows 7
to 39 for A, B, C, D colms), the same values should automatically be copied
onto the summary sheet.

2) say for example 1st worksheet has a project name "xyz CR", and again to
track for next month in 2nd worksheet i enter the same project name "xyz CR".
This duplicate should not be entered in the summary sheet.