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