I have a workbook with multiple pages. There is a master page that I have
titled Hot Sheet. It contains all of the data for all agents. The other
sheets contain the same data, but only for a specific agent. Currently, I
have to type the data onto the Hot Sheet and to the perspective agent's
sheet. I want the data in a row to copy to the agents correct sheet,
omitting blank spaces. The filtering factor could either be agent name that
I input in column C of the Hot Sheet or the color of the row, because each
row is highlighted with a color that is specific to that agent. Ex:

ID DATE AGENT CLIENT ADDRESS ETC
1234 01/09/10 FRANK DOE, JOHN 121 No Name Road etc
3274 01/10/10 BRENT DOE, JANE 321 No Name Street etc
5978 12/12/09 CHAY SMITH, JON 972 My Steet etc
6547 11/11/09 FRANK JONES, JANE 111 Your Street etc

Above is the hotsheet. Now, I need to automatically fill Frank's sheet as
follows:
ID DATE AGENT CLIENT ADDRESS ETC
1234 01/09/10 FRANK DOE, JOHN 121 No Name Road etc
6547 11/11/09 FRANK JONES, JANE 111 Your Street etc