Transfer Cell Range Value data from Sub-Workbook to Master-Workbook

[JimBarrro]

I have sub-workbooks and I want to transfer a range of cell data into a master workbook. The data transfered has the same size of cells but with the cells in a different position (ie Sub-Workbook sheet 1 (A1:C3) to master workbook sheet 12 (E1:G3)). Can you give me some help. Here is the code I have so far. Thanks:

Workbooks("e:\project\111\O.xls").Sheets("Sheet22").Activate
t=Range("D3:G6")Workbooks("e:\project\Old.xls").Sheets("Sheet1").Activate
Range("T13:W16")=t
Me.Application.Workbooks("e:\project\111\O.xls").Close(SaveChanges:=False)