Macro to create list from master sheet

Hi!

I need to create a macro that will generate individual lists for employees based off a master sheet. on my master sheet (that is what the sheet is named within the workbook) I have a huge list of stores in column A that I am constantly adding to, with the number of times each store needs to be visited listed in column B, and the employee that each store is allocated to in column C. There are only about 6 employees, so I need the macro to create 6 lists (one for each employee) when run each week that just show who they need to visit and how often. This list is updated weekly. Can someone please help??