Hello,

I am trying to find a way to move a worksheet to another document. The
document named is in a cell.

Sub MoveSheet()
'
' Range("B27").Activate
ActiveWindow.DisplayWorkbookTabs = True

Range("B5").Select
Selection.Copy
Sheets("Sheet1").Select
Sheets("Sheet1").Name = [b5]

ActiveSheet.Move After:=Workbooks("John Smith.xls").Worksheets(1)

End Sub

All files that I will be moving to will have the assocaites name, but
next time the Person will be Jane Smith or Joe Browm.

I would like to move the sheet to [A1].xls
Is this possible?

Glen Munro