copy specific data from outside data source

I am trying to import partial data from an outside excel file. I have the code so far to open the outside Excel file but I can’t figure out how to copy only certain columns and rows of data.

Please Login or Register  to view this content.

Once the outside file has been opened, I need to copy as follows (without deleting any columns as I need the values to compute other data once I have this part working):

copy column A (sourceWkb) to column A (destinationWkb)
copy column C (sourceWkb) to column C (destinationWkb)
copy column F (sourceWkb) to column D (destinationWkb)
copy column H (sourceWkb) to column F (destinationWkb)
copy column J (sourceWkb) to column G (destinationWkb)

There is also one other criteria, which is the only copy rows in which the value in column G for the sourceWkb = “Chicago”

I have attached a copy of data file and copy of file with desired results.