Sync Sheets

[thewabbit]

Hi all

I have a workbook with about 10 different sheets. The first sheet is a master sheet which contains all the data in the workbook. the other 9 sheets use advance filters to get the data onto the unique pages using this code (or similar):

   Sheets("Master").Columns("B:L").AdvancedFilter Action:=xlFilterCopy, _
        CriteriaRange:=Sheets("Master").Range("R13:R14"), CopyToRange:=Sheets("Dave Bell").Range( _
        "A2:K2"), Unique:=False

What I'd like to be able to do, is edit the data on each seperate sheet and have that changed data replace what is on the master. any ideas how that would be done?

cheers