VBA MAcro update master sheet by row and column of csv

[LNG2013]

I need help with some VBA macro code that will look at the dates in the header and names in row A, and then use the corresponding information to update a Master Spreedsheet that has more names and dates. There will be many CSVs that are produced daily, each with different names and dates. Names and Dates are static in the Master sheet.

CSV Table Layout:
<STYLE type=text/css>
table.tableizer-table {border: 1px solid #CCC; font-family: Arial, Helvetica, sans-serif; font-size: 12px;} .tableizer-table td {padding: 4px; margin: 3px; border: 1px solid #ccc;}
.tableizer-table th {background-color: #104E8B; color: #FFF; font-weight: bold;}
</STYLE>

<style type="text/css">
table.tableizer-table {border: 1px solid #CCC; font-family: Arial, Helvetica, sans-serif; font-size: 12px;} .tableizer-table td {padding: 4px; margin: 3px; border: 1px solid #ccc;}
.tableizer-table th {background-color: #104E8B; color: #FFF; font-weight: bold;}
</style>
<table class="tableizer-table">
<tr class="tableizer-firstrow"><th></th><th> </th><th> </th><th> </th></tr> <tr><td> </td><td>A</td><td>B</td><td>C</td></tr> <tr><td>1</td><td>Names</td><td>8/6/2011</td><td>Notes-8/6/2011</td></tr> <tr><td>2</td><td>Bill</td><td>Here</td><td> </td></tr> <tr><td>3</td><td>Sue</td><td>Late</td><td>Late 10 Min</td></tr></table>


Example of final Master sheet:

<STYLE type=text/css>
table.tableizer-table {border: 1px solid #CCC; font-family: Arial, Helvetica, sans-serif; font-size: 12px;} .tableizer-table td {padding: 4px; margin: 3px; border: 1px solid #ccc;}
.tableizer-table th {background-color: #104E8B; color: #FFF; font-weight: bold;}
</STYLE>
<TABLE class=tableizer-table>
<TBODY><TR class=tableizer-firstrow><TH></TH><TH></TH><TH></TH><TH></TH><TH></TH><TH></TH><TH></TH></TR><TR><TD></TD><TD></TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD></TR><TR><TD></TD><TD>1</TD><TD>Names</TD><TD>8/5/2011</TD><TD>Notes-8/5/2011</TD><TD>8/6/2011</TD><TD>Notes-8/6/2011</TD></TR><TR><TD></TD><TD>2</TD><TD>Bill</TD><TD>Here</TD><TD></TD><TD>Here</TD><TD></TD></TR><TR><TD></TD><TD>3</TD><TD>Bob</TD><TD>Sick</TD><TD></TD><TD>Here</TD><TD></TD></TR><TR><TD></TD><TD>4</TD><TD>Mary</TD><TD>Here</TD><TD></TD><TD>Here</TD><TD></TD></TR><TR><TD></TD><TD>5</TD><TD>Sue</TD><TD>Late</TD><TD>Late 5 Min</TD><TD>Late</TD><TD>Late 10 Min</TD></TR>


</TABLE>




Any Ideas?