Macro insert multiple sheet and insert age band based on numbers

Macro insert multiple sheet and insert age band based on numbers
Hi,
I have a data in Sheet “Data”. In Sheet “Data” I have age of all members in Column ‘E’.

In next sheet “Age Band” I have different types of Age Band in Different Columns.

Macro to do below mentioned task.

1) Create New Sheet. Sheet Name Should be heading of the first column in from Sheet “Age Band”. Example sheet given (Sheet “ABC”).
2) Copy entire records from Sheet “Data” till the end of serial number and paste the same in newly created sheet.
3) Now in newly created sheet “ABC” in column ‘F’, pull age band mentioned below heading of ABC from Sheet “Age Band”.

After above task again new sheet to be created and sheet name should be the second heading from Sheet “Age Band” and repeat task no 2 and 3. Please refer example sheet.

Please note:
Number of newly created sheet be equal to number of headings (ABC,BDC, ASD) in sheet “age band”
All records till the end of serial number (Column-A) to be copied in new sheets.
Before creating any new sheet, first check whether with the same name already sheets is exist or Not. If exist then delete the same and then create new sheet.
Please provide steps remarks against all code. So that I can change it later on as per our requirement.