First Scenario: We are trying to copy over data from a range of cells from
one worksheet into added request(s) sheets that users have already added once
return to us. I have created the following to repeat the copying of the
first added sheet, but the user can add multiples and want this to loop
through the rest of the worksheets added without errors coming up due to the
worksheet name change Request (2) to Request (3) and so forth?

Range("P5:R5").Select
Range("P5:R5").Copy
Sheets("Request (2)").Select
Range("P5:R5").Select
ActiveSheet.Paste

Second Scenario: We are trying to have the worksheet to be renamed once the
user types in an user's name in the TEXT BOX.....unable to get this to work.
We know how to do this when working with Excel cells itself, but not a TEXT
BOX? Any suggestions??

Any help would be greatly appreciated it.

Linda