Distribute Data from One Main Worksheet to Several Other Worksheets

Greetings Forum;

I have searched for this but did not find anything here that seemed to help – I hope I searched logically.

I am in need of an Excel Macro to help me create an address list by market. For simplicity sake I’ll set up a mini-example: I have an Excel document with a MASTER tab that lists the Market (Column A), a person’s name (Column B) and their Phone number (Column C). What I need to macro to do is read column A and make a new tab for each market in that column, then populate the name and phone fields accordingly.

A found one macro that was close, but it does not automatically make a new tab (I have to do that manually) and it does not refresh the sheet each time I open it, so when I run the macro again I get duplicate entries. I’m not an Excel expert and will never be able to repay and help I get in kind, so I hope one of you experts takes pity on me and can offer some help.

Thanks in advance,