well, no one else has tried, so i'll give it a go. please save your
work before running this macro. i did not make it an automatic
worksheet_change as you requested, because it would be running
constantly & would not work correctly, i don't think. instead, i made
it as a stand-alone that would be run once or twice a day.

watch out for the two longest lines (setting the ranges). they will
definitely wrap the text in the newsgroup reader! you will have to un-
wrap them. i wasn't sure how to break them up in the coding.
=======================
Option Explicit

Sub Ranjit()

Dim myLastRow As Long
Dim mySheet As Worksheet
Dim WS As Worksheet
Dim mySheetName As String
Dim myShtRow As Long
Dim myRange As Range
Dim myOtherRange As Range
Dim myCell As Range

Set WS = Worksheets("Master")
myLastRow = WS.Cells(20000, 1).End(xlUp).Row
Set myCell = WS.Range("a2")

Do Until myCell.Row = myLastRow
If myCell.Offset(0, 1).Value = Date Then
Set myRange = WS.Range("a" & myCell.Row & ":e" & myCell.Row)
'unwrap me
mySheetName = myCell.Text
Set mySheet = Worksheets(mySheetName)
myShtRow = mySheet.Cells(20000, 1).End(xlUp).Row + 1
Set myOtherRange = mySheet.Range("a" & myShtRow & ":e" &
myShtRow) 'unwrap me
myRange.Copy Destination:=myOtherRange
End If
Set myCell = myCell.Offset(1, 0)
Loop

End Sub
====================
hope it at least gets you started!
:)
susan



On Jun 25, 5:35*am, Ranjit kurian
wrote:
Hi

I have a master sheet in excel which contain all the below details as per
sheet names('status' column are the sheet names)

Status *Date * *Patient ID * * *Docter Name * * Region
Critical * * * *6/25/2008 * * * 34567 * Suhas * * * * * * * * *IE
Died * *6/25/2008 * * * 12345 * Pradeep * * * * * * US

This master sheet is updated on daily bases, new recordes will been added on
daily, i need a macro so that when ever the new recordes are added to the
master sheet , all the other sheets similutaneous need to be filled example:

if the Status column is Critical then what ever details is update next to
that column need to filled in Critical Sheet.......

The macro should match the sheet name and mastersheet data , then it should
copy the related details to that particular sheet