I have not been successful in finding the right macro in some of the other posts... I am very new to VBA.

I have a Master sheet with data that I continually update. In Column C I have different hospitals listed (Red, Blue, Green, for example) and I have different sheets for each hospital (Red, Blue, Green). I would like to have a macro that will copy any row that I add to the Master sheet with "Red" in column C to the Red sheet, "Blue" to the Blue sheet, etc...

Is it easier to simply make three separate buttons (Red, Green, Blue) on the Master sheet which I could click every time I add a line to the Master sheet, which would copy that particular row at the time? Kind of like a "copy row to ***" button.

Thanks. I'm using Excel 2011 for Mac.