I have a master sheet of data for a number of individuals and would like to create a sheet for each for their ease.

For example:
Master Sheet

A b c
Jane Doe amount 1 reason 1
Jon Doe amount 2 reason 2
Tom Smith amount 3 reason 3
Jane Doe amount 4 reason 4
Jon Doe amount 5 reason 5
Tom Smith amount 6 reason 6
Jane Doe amount 7 reason 7
Jane Doe amount 8 reason 8
Tom Smith amount 9 reason 9

I'd like to have sheets for Jane Doe, Jon Doe and Tom Smith. Jane Doe's sheet would look like:

A B
amount 1 reason 1
amount 4 reason 4
amount 7 reason 7
amount 8 reason 8

IN order to accomplish this, can I use a formula or do I need some VB code? If code, any way to make the macro automatic, such as when it's opened or printed?

Thanks.