Here is sktneer's file edited to be able to be used in your version of Excel. The only things wrong with the file was the number of columns addressed in the original file and the file format that the file was saved under. As data is entered on the first worksheet the second worksheet updates automatically as you requested.
Nice work sktneer!
Bookmarks