Copy between workbooks from a third workbook.

Hello,
I would like to make an excel macro that will sit in a stand alone workbook (Workbook1).
This macro would select a single user-defined worksheet from Workbook2 and paste it in to Workbook 3.
I can get it to copy the worksheet from Workbook 2 but getting it to paste into Workbook 3 is a bit beyond me. Any help will be greatly appreciated.

Here is my current code which copies from Workbook2 and pastes into Workbook1.
I played around with trying to get it to paste to Workbook3 but it all fell in a heap :)
I'm using Excel 2007.

Sub GetFile()
Sheets("menu").Select
PathName = Range("D3").Value
Filename = Range("D4").Value
Worksheet = Range("D5").Value
TabName = Range("D6").Value
ControlFile = ActiveWorkbook.Name
Workbooks.Open Filename:=PathName & Filename
Worksheets(Worksheet).Activate
ActiveSheet.Name = TabName
Sheets(TabName).Copy After:=Workbooks(ControlFile).Sheets(1)
Windows(Filename).Activate
ActiveWorkbook.Close SaveChanges:=False
Windows(ControlFile).Activate
Sheets("menu").Select
Range("D9").Select
ActiveCell.Value = "Completed"
Range("D10").Select
End Sub