Update master file columns with columns from slave files

I'm new here and my current work scope requires a lot of Excel data manipulations using VBA / macros. I have a situation here:

1. I have a master file (Leads.xls) that contains sales leads. Everyday new sales leads will be assigned with salesperson (column G - PFM) and appended to the existing leads.
2. Once assigned, leads will be parsed into individual worksheets using a macro (‘Parse Data’ button).
3. After successful parsing, individual workbooks will be created based on the individual worksheets (Kelvin.xls, Evelyn.xls and Bob.xls) by running a macro (‘Create Excel’ button).
4. Each salesperson will have their own workbooks and will work on making sales. At the end of the day, salesperson will fill in column H – O (1st Attempt – Drop Case).

My predicament now is to match back each salesperson data in individual workbooks with master file workbook and update their respective H – O columns into the master file. I have gone through this and other forums for ideas but the closest would be

http://www.excelforum.com/excel-gene...ple-files.html

but there is a setback of implementing the plugin – my network hinders me from downloading and installing unknown plugins into our computers. My ideas would be:

a. Put all individual files into a folder for easy referencing purposes.
b. Run vlookup for each column (in master file) that require updates.
c. Similar to ‘Parse Data’ and ‘Create Excel’ buttons, a button will be created with a macro to populate the respective columns in master file from individual workbooks.

Appreciate if you guys could help me with this.