View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
lana.b lana.b is offline
external usenet poster
 
Posts: 5
Default collecting fata from all sheets into one sheet

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