Moving data between sheets based on data content

Hello!
I need some help with figuring out how to move data from a group of worksheets into another group of worksheets within the same workbook. Sounds easy, right?

I have data split into 3 monthly worksheets: April, May, June.
Each of these worksheets includes a names column in Column A, a month column in Column B, as well as other columns of interest.

What I want to do is to

1. Create one worksheet for each one of the names in Column A.
2. Copy rows pertaining to each NAME in column A into their respective named worksheets.

In other words, my data is now grouped by month, but I would like to group it by Name.

The idea here is that the data in each of the personal sheets will be automatically used to create charts. If I were to add a fourth (July) sheet, everything would run smoothly by running the macro (ie. adding an additional row and updating the charts)

My approach here is to combine all of the data into one master sheet and run an SQL query, but I have not been able to put this together.

Any and all help would be greatly appreciated!

Thank you