Help Aggregating Excel files...

[WilliamDecker]

Hello,

Let me preface first this is more of an excel best practice than how to complete the task I want to do. You'll see in a second that there are multiple answers to this question, but I'm looking for the best answer (as my solution is no longer practical).

I work for a company that does weekly reporting through a server based program that access' a large database of information. I do not have access to this servers information (red tape) and the only way to obtain the information I need is by exporting excel data from our servers.

Basically it's weekly reporting for the previous week on various metrics. For each area of our business we have a separate excel file. An example can be seen in the following:

<script language="JavaScript" src="http://www.interq.or.jp/sun/puremis/colo/popup.js"></script><center><table align="center" cellpadding="0" cellspacing="0"><tbody><tr><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-left: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0);" colspan="15" bgcolor="#0c266b"><table align="center" border="0" width="100%"><tbody><tr><td align="left">Microsoft Excel - Title of Downloaded File.xls</td><td style="font-size: 9pt; color: rgb(255, 255, 255); font-family: caption;" align="right">___Running: 11.0 : OS = Windows XP </td></tr></tbody></table></td></tr><tr><td style="border-left: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0); height: 25px;" colspan="15" bgcolor="#d4d0c8"><table valign="MIDDLE" align="center" border="0" width="100%"><tbody><tr><td style="font-size: 10pt; color: rgb(0, 0, 0); font-family: caption;">(F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout</td><td align="right" valign="center"><form name="formCb605117"><input onclick='window.clipboardData.setData("Text",document.formFb202339.sltNb447362.value);' value="Copy Formula" name="btCb942116" type="button"></form></td></tr></tbody></table></td></tr><tr><td style="border-left: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0);" colspan="15" bgcolor="white"><table border="0"><tbody><tr><form name="formFb202339"></form><td style="width: 60px;" align="middle" bgcolor="white"><select onchange="document.formFb202339.txbFb150492.value = document.formFb202339.sltNb447362.value" name="sltNb447362"><option value="1.7" selected="selected">A1</option></select></td><td align="right" bgcolor="#d4d0c8" width="3%">=</td><td align="left" bgcolor="white"><input size="80" value="Title of Downloaded File 1" name="txbFb150492"></td></tr></tbody></table></td></tr><tr><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-left: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0); background-color: rgb(212, 208, 200);" align="middle" width="2%">
</td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: black; font-family: menu; background-color: rgb(212, 208, 200);" align="middle"><center>A</center></td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: black; font-family: menu; background-color: rgb(212, 208, 200);" align="middle"><center>B</center></td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: black; font-family: menu; background-color: rgb(212, 208, 200);" align="middle"><center>C</center></td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: black; font-family: menu; background-color: rgb(212, 208, 200);" align="middle"><center>D</center></td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: black; font-family: menu; background-color: rgb(212, 208, 200);" align="middle"><center>E</center></td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: black; font-family: menu; background-color: rgb(212, 208, 200);" align="middle"><center>F</center></td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: black; font-family: menu; background-color: rgb(212, 208, 200);" align="middle"><center>G</center></td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: black; font-family: menu; background-color: rgb(212, 208, 200);" align="middle"><center>H</center></td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: black; font-family: menu; background-color: rgb(212, 208, 200);" align="middle"><center>I</center></td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: black; font-family: menu; background-color: rgb(212, 208, 200);" align="middle"><center>J</center></td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: black; font-family: menu; background-color: rgb(212, 208, 200);" align="middle"><center>K</center></td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: black; font-family: menu; background-color: rgb(212, 208, 200);" align="middle"><center>L</center></td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: black; font-family: menu; background-color: rgb(212, 208, 200);" align="middle"><center>M</center></td><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: black; font-family: menu; background-color: rgb(212, 208, 200);" align="middle"><center>N</center></td></tr><tr><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-left: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: rgb(0, 0, 0); font-family: menu; background-color: rgb(212, 208, 200);" align="middle" width="2%"><center>1</center></td><td style="border-style: solid; border-color: rgb(0, 0, 0) rgb(212, 208, 200) rgb(212, 208, 200) rgb(0, 0, 0); border-width: 0.5pt; font-size: 18pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: left;" colspan="14">Title of Downloaded File 1</td></tr><tr><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-left: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: rgb(0, 0, 0); font-family: menu; background-color: rgb(212, 208, 200);" align="middle" width="2%"><center>2</center></td><td style="border-left: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;"> </td><td style="border-right: 0.5pt solid rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(212, 208, 200); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;"> </td></tr><tr><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-left: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: rgb(0, 0, 0); font-family: menu; background-color: rgb(212, 208, 200);" align="middle" width="2%"><center>3</center></td><td style="border-left: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-size: 8pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;" colspan="14"> </td></tr><tr><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-left: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: rgb(0, 0, 0); font-family: menu; background-color: rgb(212, 208, 200);" align="middle" width="2%"><center>4</center></td><td style="border-left: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-size: 8pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Tahoma; background-color: rgb(255, 255, 255); text-align: right;" colspan="14"> </td></tr><tr><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-left: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: rgb(0, 0, 0); font-family: menu; background-color: rgb(212, 208, 200);" align="middle" width="2%"><center>5</center></td><td style="border-left: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;"> </td><td style="border-right: 0.5pt solid rgb(212, 208, 200); border-bottom: 0.5pt solid rgb(212, 208, 200); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;"> </td><td style="border-right: 0.5pt solid rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(212, 208, 200); font-size: 10pt; vertical-align: bottom; color: rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;"> </td></tr><tr><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-left: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: rgb(0, 0, 0); font-family: menu; background-color: rgb(212, 208, 200);" align="middle" width="2%"><center>6</center></td><td style="border-left: 0.5pt solid rgb(192, 192, 192); border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-weight: bold; font-size: 8pt; vertical-align: top; color: rgb(51, 51, 153); font-family: Arial; background-color: rgb(255, 255, 153); text-align: left;">Date</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(212, 208, 200); font-size: 9pt; vertical-align: top; color: rgb(192, 192, 192); font-family: Verdana; background-color: rgb(102, 102, 153); text-align: left;">Metrics</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(212, 208, 200); font-weight: bold; font-size: 9pt; vertical-align: top; color: rgb(255, 255, 255); font-family: Verdana; background-color: rgb(102, 102, 153); text-align: center;">Metric 1</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(212, 208, 200); font-weight: bold; font-size: 9pt; vertical-align: top; color: rgb(255, 255, 255); font-family: Verdana; background-color: rgb(102, 102, 153); text-align: center;">Metric 2</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(212, 208, 200); font-weight: bold; font-size: 9pt; vertical-align: top; color: rgb(255, 255, 255); font-family: Verdana; background-color: rgb(102, 102, 153); text-align: center;">Metric 3</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(212, 208, 200); font-weight: bold; font-size: 9pt; vertical-align: top; color: rgb(255, 255, 255); font-family: Verdana; background-color: rgb(102, 102, 153); text-align: center;">Metric 4</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(212, 208, 200); font-weight: bold; font-size: 9pt; vertical-align: top; color: rgb(255, 255, 255); font-family: Verdana; background-color: rgb(102, 102, 153); text-align: center;">Metric 5</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(212, 208, 200); font-weight: bold; font-size: 9pt; vertical-align: top; color: rgb(255, 255, 255); font-family: Verdana; background-color: rgb(102, 102, 153); text-align: center;">Metric 6</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(212, 208, 200); font-weight: bold; font-size: 9pt; vertical-align: top; color: rgb(255, 255, 255); font-family: Verdana; background-color: rgb(102, 102, 153); text-align: center;">Metric 7</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(212, 208, 200); font-weight: bold; font-size: 9pt; vertical-align: top; color: rgb(255, 255, 255); font-family: Verdana; background-color: rgb(102, 102, 153); text-align: center;">Metric 8</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(212, 208, 200); font-weight: bold; font-size: 9pt; vertical-align: top; color: rgb(255, 255, 255); font-family: Verdana; background-color: rgb(102, 102, 153); text-align: center;">Metric 9</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(212, 208, 200); font-weight: bold; font-size: 9pt; vertical-align: top; color: rgb(255, 255, 255); font-family: Verdana; background-color: rgb(102, 102, 153); text-align: center;">Metric 10</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(212, 208, 200); font-weight: bold; font-size: 9pt; vertical-align: top; color: rgb(255, 255, 255); font-family: Verdana; background-color: rgb(102, 102, 153); text-align: center;">Metric 11</td><td style="border-right: 0.5pt solid rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(212, 208, 200); font-weight: bold; font-size: 9pt; vertical-align: top; color: rgb(255, 255, 255); font-family: Verdana; background-color: rgb(102, 102, 153); text-align: center;">Metric 12</td></tr><tr><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-left: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: rgb(0, 0, 0); font-family: menu; background-color: rgb(212, 208, 200);" align="middle" width="2%"><center>7</center></td><td style="border-left: 0.5pt solid rgb(192, 192, 192); border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(51, 51, 153); font-family: Arial; background-color: rgb(255, 255, 255); text-align: left;" colspan="2">Sun, 08-Feb-09</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;"> </td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">0.0</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">0</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">0</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">0</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">0.0</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">0</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">0</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">0.0</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">0.0</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">0.0</td><td style="border-right: 0.5pt solid rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">0.0</td></tr><tr><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-left: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: rgb(0, 0, 0); font-family: menu; background-color: rgb(212, 208, 200);" align="middle" width="2%"><center>8</center></td><td style="border-left: 0.5pt solid rgb(192, 192, 192); border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(51, 51, 153); font-family: Arial; background-color: rgb(255, 255, 255); text-align: left;" colspan="2">Mon, 09-Feb-09</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">1</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">1.1</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">1,001</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">1,001</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">1,001</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">1.1</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">1,001</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">1,001</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">1.1</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">1.1</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">1.1</td><td style="border-right: 0.5pt solid rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">1.1</td></tr><tr><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-left: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: rgb(0, 0, 0); font-family: menu; background-color: rgb(212, 208, 200);" align="middle" width="2%"><center>9</center></td><td style="border-left: 0.5pt solid rgb(192, 192, 192); border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(51, 51, 153); font-family: Arial; background-color: rgb(255, 255, 255); text-align: left;" colspan="2">Tue, 10-Feb-09</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">2</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">1.2</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">1,002</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">1,002</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">1,002</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">1.2</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">1,002</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">1,002</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">1.2</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">1.2</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">1.2</td><td style="border-right: 0.5pt solid rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">1.2</td></tr><tr><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-left: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: rgb(0, 0, 0); font-family: menu; background-color: rgb(212, 208, 200);" align="middle" width="2%"><center>10</center></td><td style="border-left: 0.5pt solid rgb(192, 192, 192); border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(51, 51, 153); font-family: Arial; background-color: rgb(255, 255, 255); text-align: left;" colspan="2">Wed, 11-Feb-09</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">3</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">1.3</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">1,003</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">1,003</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">1,003</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">1.3</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">1,003</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">1,003</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">1.3</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">1.3</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">1.3</td><td style="border-right: 0.5pt solid rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">1.3</td></tr><tr><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-left: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: rgb(0, 0, 0); font-family: menu; background-color: rgb(212, 208, 200);" align="middle" width="2%"><center>11</center></td><td style="border-left: 0.5pt solid rgb(192, 192, 192); border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(51, 51, 153); font-family: Arial; background-color: rgb(255, 255, 255); text-align: left;" colspan="2">Thu, 12-Feb-09</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">4</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">1.4</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">1,004</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">1,004</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">1,004</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">1.4</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">1,004</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">1,004</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">1.4</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">1.4</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">1.4</td><td style="border-right: 0.5pt solid rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">1.4</td></tr><tr><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-left: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: rgb(0, 0, 0); font-family: menu; background-color: rgb(212, 208, 200);" align="middle" width="2%"><center>12</center></td><td style="border-left: 0.5pt solid rgb(192, 192, 192); border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(51, 51, 153); font-family: Arial; background-color: rgb(255, 255, 255); text-align: left;" colspan="2">Fri, 13-Feb-09</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">5</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">1.5</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">1,005</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">1,005</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">1,005</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">1.5</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">1,005</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">1,005</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">1.5</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">1.5</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">1.5</td><td style="border-right: 0.5pt solid rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">1.5</td></tr><tr><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-left: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: rgb(0, 0, 0); font-family: menu; background-color: rgb(212, 208, 200);" align="middle" width="2%"><center>13</center></td><td style="border-left: 0.5pt solid rgb(192, 192, 192); border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(51, 51, 153); font-family: Arial; background-color: rgb(255, 255, 255); text-align: left;" colspan="2">Sat, 14-Feb-09</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">6</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">1.6</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">1,006</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">1,006</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">1,006</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">1.6</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">1,006</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">1,006</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">1.6</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">1.6</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">1.6</td><td style="border-right: 0.5pt solid rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(192, 192, 192); font-size: 8pt; vertical-align: top; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(255, 255, 255); text-align: right;">1.6</td></tr><tr><td style="border-top: 0.5pt solid rgb(0, 0, 0); border-left: 0.5pt solid rgb(0, 0, 0); font-size: 10pt; color: rgb(0, 0, 0); font-family: menu; background-color: rgb(212, 208, 200);" align="middle" width="2%"><center>14</center></td><td style="border-left: 0.5pt solid rgb(192, 192, 192); border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-weight: bold; font-size: 9pt; vertical-align: middle; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(192, 192, 192); text-align: left;" colspan="2">Total</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-weight: bold; font-size: 9pt; vertical-align: middle; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(192, 192, 192); text-align: right;">7</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-weight: bold; font-size: 9pt; vertical-align: middle; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(192, 192, 192); text-align: right;">1.7</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-weight: bold; font-size: 9pt; vertical-align: middle; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(192, 192, 192); text-align: right;">1,007</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-weight: bold; font-size: 9pt; vertical-align: middle; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(192, 192, 192); text-align: right;">1,007</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-weight: bold; font-size: 9pt; vertical-align: middle; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(192, 192, 192); text-align: right;">1,007</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-weight: bold; font-size: 9pt; vertical-align: middle; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(192, 192, 192); text-align: right;">1.7</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-weight: bold; font-size: 9pt; vertical-align: middle; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(192, 192, 192); text-align: right;">1,007</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-weight: bold; font-size: 9pt; vertical-align: middle; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(192, 192, 192); text-align: right;">1,007</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-weight: bold; font-size: 9pt; vertical-align: middle; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(192, 192, 192); text-align: right;">1.7</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-weight: bold; font-size: 9pt; vertical-align: middle; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(192, 192, 192); text-align: right;">1.7</td><td style="border-right: 0.5pt solid rgb(192, 192, 192); border-bottom: 0.5pt solid rgb(192, 192, 192); font-weight: bold; font-size: 9pt; vertical-align: middle; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(192, 192, 192); text-align: right;">1.7</td><td style="border-right: 0.5pt solid rgb(0, 0, 0); border-bottom: 0.5pt solid rgb(192, 192, 192); font-weight: bold; font-size: 9pt; vertical-align: middle; color: rgb(0, 0, 128); font-family: Arial; background-color: rgb(192, 192, 192); text-align: right;">1.7</td></tr><tr><td style="border-style: solid; border-color: rgb(128, 128, 128) rgb(0, 0, 0) rgb(0, 0, 0); border-width: 0.5pt; background-color: rgb(212, 208, 200);" colspan="15"><table valign="TOP" align="left" width="100%"><tbody><tr><td style="border-style: solid; border-color: rgb(128, 128, 128) rgb(0, 0, 0) rgb(0, 0, 0); border-width: 0.5pt; width: 120pt; background-color: rgb(255, 255, 255);" align="left">Title of Downloaded File 1</td><td> </td></tr></tbody></table></td></tr></tbody></table>
[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.</center>

What I'm trying to do is aggregate all data from inside each of these excel files (there are approximately 41 files) into a master file.

What I'm trying to find out is what is the easiest way to automate this process? If you need more details on what the master file looks like it's just a better looking excel file for the suits that shows the metrics in the files and then % increase/decrease over our predicted numbers. Basic stuff, but I can provide the visual if requested. Just wanted to keep this as concise (ha!) as possible without missing any details

Besides going in the master file and linking to each of the 41 excel files manually can anyone direct me to a method of doing this efficiently? I'm not afraid of learning or reading, but I am hoping someone with a lot more excel experience can recommend a smart method of doing this. Manual linking can only lead to future headaches from my experience (although to be honest it's better than copying/pasting manual data).

Suggestions? Ideas? Any help in the right direction is going to hopefully help save the little hair I have left.

Thanks in advance!

William Decker