I don't use VBA that much and really need to figure this out. I need to create a macro that will perform the following steps:

1. Select sheet "Trigger"
2. Copy Sheet Name from a list starting in "AV42"
3. Go to sheet "PDR"
4. Rename Sheet copied from step 2 above
5. Select sheet "Trigger"
6. Copy Title from a list starting in "AR42"
7. Go to sheet that was recently renamed
8. Paste Title into cell A1
9. Select sheet "Trigger"
10. Copy Description from a list starting in "AS42"
11. Go to sheet that was recently renamed
12. Paste Description into cell B1
13. Copy sheet to New Sheet
Repeat 1-13

This can be done in 3 different loops if that's easier
1. Copy Sheet Multiple times
2. Copy/Paste Title from list to new sheets
3. Copy/Paste Description from list to new sheets

Can someone please provide the code to accomplish these tasks?