Macro to create multiple sheet, copy certain values and loop until end of row data

Let me summarize what the macro intends to do:
1. Create copy of sheet2 based on names on sheet1
2. Rename the sheets accordingly
3. Auto-populate certain values (name, etc.)
4. Create formula or absolute references to each named wsheet (on sheet1, adjacent to the name) before it proceeds with creating another worsheet with next name (loop until EOF)

thanks for all the help!