Export/ Retrieve specific data from multiple workbooks and Import into Master workbook

In one script I need these actions to be performed.

Question: How to create a macro in Excel 2007 to export/pull specific data from 2 separate workbooks and import into one master workbook?

Requirements: (See attached example documents)

1. Need Macros to search ‘Commercial Time Card.xlsx’ by Employee name and Commercial Contract #.
a. (i.e) Derrick Johnson, ABV00000089
2. Extract/Export all previous week ending actuals (up to the current ‘week ending’ date) (Extract Number values only, Do Not paste the “H”).
a. (i.e) Copy Column L through Column CL. (C:CL)
3. Import ‘week ending ‘ actuals into ‘Employee Staff.xlsm’ document. Paste data into matching employee name and Commercial Contract # cells respectively.
a. (i.e) Paste copied data into Column D through Column DE. (D:DE)
4. Also export “Overall Results” number values to “Sum” column in ‘Employee Staff.xlsm’ document.
a. (i.e) Copy data from Column CM in ‘Commercial Time Card.xlsx’ ,
b. Paste data into Column DU.
5. Repeat process 1-4 to export data from ‘Retail Time Card.xlsx’ document (2nd workbook) and imported into the ‘Employee Staff.xlsm’ document.
Note: The Commercial Time Card.xlsm’ and ‘Retail Time Card’ documents are updated weekly. A new column is added to contain the weeks latest labor actual. I Need the macro to be able to still pull data from each new column each week. Need the 'E,ployee Staff.xlsx' to stay updated to reflect newest data/

How to create a macro to incorporate these request?
Thanks,
Serenity