Copy rows from 1 sheet by Group

[rogerabhi]

I have attached an Excel book. I am very new to Excel VBA, hence request to please help me in building a macro with this:

Sheet1 contains data for groups and subgroups as shown.

Sheet2 contains multiple rows for each sub group.

How do I write a macro so that it dos the following things:

1. Iterate Sheet1 and create new sheets based on Group name. Here, create 4 new sheets as A, B, C, D

2. Iterate Sheet2 and copy rows of sub groups to the corresponding Group sheets which are newly created. Ex: Copy all rows starting with 'aa' or 'aaa' to the group sheet A

3. Similarly carry out for other groups

The data in Sheet1 and Sheet2 can be changed and the macro should handle it accordingly.