Excel Auto-Sheet Generator

I maintain one master worksheet that holds mixed data—numbers alongside text. As new rows are added I want the workbook to look at a particular column, treat each distinct value it finds as a key, and… (Budget: $30 - $250 SGD, Jobs: Data Analysis, Data Management, Data Processing, Excel, Excel Macros, Excel VBA, Visual Basic, Visual Basic for Apps)