Hi Lana,
Thought I'd try to help you whilst I'm waiting for someone to help me out.

In your master sheet, click in field A1 (or where ever you want to show the
data) then press =, then click user1's sheet and click the A1 field and
press return.
When you return to your master sheet, field A1 will have the value of field
A1 from user1's sheet.
Alternatively you can just enter the reference manually so if user1's sheet
is called sheet1 then enter =Sheet1!A1 in your master sheet to see the value
in A1 from user1.
Hope that makes sense.

I'm not sure how password protection works, so this may hinder my answer.

Jon








"lana.b" .(dontspam) wrote in message
...
Dear all,

i have one worksheet divided into 20 tab( sheets) all sheets with the same
templates but for different users, but i want sheet 21 have all data from
the
other sheets.
note: each sheet has a password for its user , so i need sheet 21 to be
the
master sheet and updated at the same, if one user makes some changes on
any
record,this should automatically reflected in sheet 21 .
plz plz help ASAP
--
with regards
L.B