Copy certain tabs to a new workbook based on criteria

Howdy folks - I think this should be easy enough to solve based on one criteria and copying to one new workbook as paste special/values. But I think someone could possibly even solve my issue further so that after copying to a new workbook based on one criteria, the macro goes on copying certain tabs to the next workbook based on the next criteria. Let me explain

Tab names as follows:
Menu, Tab 1, Tab 2, Tab3....................... Tab50

Each tab contains a persons name in cell G1:
Danny
John
Gavin
Mark
etc.

Danny has his name in 10 of the 50 tabs.

So I have a unique list of the names in the Menu tab cells A1:A30, assuming 30 different names.

Is it possible to get a macro to go to cell A1 within the Menu tab which equals Danny,
Looks for this in G1 of all the tabs in the workbook
Copies tabs that have Danny in cell G1 to a new workbook and saves as paste special>values
Then moves to the next cell in menu A2 which contains the name John,
Looks for this in G1 of all the tabs in the workbook...

So by the end I have 30 Workbooks with each person's workbook containing all their sheets which are applicable to them based on cell G1 with their name in it.

Thanks in advance folks - I have tried this a little but I don't understand how to do the same step over again and move on to the next criteria. Must go on a course for this.

This is legendary - works perfectly! Thank you very much.

Can I be really annoying and put in one small (I think?) addition... is it possible that if column B of the Menu tab contains each person's age group, that the files are saved as Age Group - Name?

So the menu tab contains the information as follows:
A B
Danny Senior
Gavin Under 21
Mark Senior

But the file is saved as column B - column A

e.g. Senior - Danny
Under 21 - Gavin
Senior - Mark