Overall, I want to create a database that tracks defects for several sites and ouputs the information in a pivot table.  Each site (7 in total) documents their internal defect data and sends it to me weekly.  I then merge all of this data (have been doing so manually) into one spreadsheet to...