Copy from open excel sheet and paste into close excel sheet

Hi:

I have attached excel files for referance

I need certain data from (Source File ) 10_2010_Store#1_DailySales to be copied into files
This is Open excel file and VB script can be in this sheet:

Destination Files - closed excel file ( i have all 31 blankfiles)
10-1-10_Store#1_REG1
10-2-10_Store#1_REG1
10-3-10_Store#1_REG1
10-4-10_Store#1_REG1 and so on until

10-31-10_Store#1_REG1.

Data need to be imported from 10_2010_Store1_DailySales


P119:Q178 into 10-1-10_Store#1_REG1 at A2:B61
T119:U178 into 10-2-10_Store#1_REG1 at A2:B61
X119:Y178 into 10-3-10_Store#1_REG1 at A2:B61

and so..(FYI : every 3rd Column data)

Let us try just for 2 files for now and then we can implement for full month.

FYI : I need to restore my daily receipt since the server they were in had crashed and i have lost daily receipts.

Please let me know if you have any questions.

Help is greatly appreciated..

Thanks...
RM