Dynamically Creating Sheets

[Todd Huttenstine]

On sheet 1, I have names of people located in range
A7:A55. I have stats for each of these people in columns
B through U. Each column contains the name of a different
stat. The name of each stat is located on row 6 (from
columns B to U). Now on sheet 4, in range A5:A17 I have
names of stats. Each stat name will match a stat name
found in row 6 of sheet 1.

I need a code that when run, will look in sheet 1 range
A7:A55, and for each person it finds, will look at sheet 4
in range A5:A17 and look at each stat name, then go back
to sheet 1 and pull the corresponding stat and put in
column B range B5:B17 corresponding to the stat in range
A5:A17. Then I need the code to copy sheet 4 and create a
new sheet with the name of the person. I need the code to
loop through this procedure until there is no more names
in range A7:A55 of sheet 1. Now if a sheet with the same
name is found in the workbook, I need it to automatically
over-write the sheet in the book.

I hope this is not confusing.


Any help is greatly appreciated.

Todd Huttenstine