The simplest answer to your first question is to type an = into the cell on
the summary worksheet where you want the data to appear then click on the
second worksheet and click on the source cell. Whatever you type in that cell
on the second worksheet will appear on the summary sheet. Copy or replicate
other data entry cells for all other data to appear on you summary sheet.
This will, however, result in a zero appearing in you summary where no data
appears on your source worksheet but can be eliminated by amending the fomula
in your summary sheet thus =IF(Sheet2!A1="","",Sheet2!A1) (amend Sheet2 and
A1 to suit).
Your second question is more complex:
If your first worksheet is named "xyz CR" you cannot name a second worksheet
in the same workbook with the same name!
Can you give more info on your layout of data?


"Max" wrote:

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.