I am trying to find a way of renaming an Excel worksheet to a value contained in one of its' cells.
The worksheet is copied with the following line:

Worksheets("Source").Copy after:=Worksheets("Last Sheet")

the code then loops and places a new set of data in the sheet "Source", and I want this new sheet copied and renamed etc. etc

Can anyone help?