I have a workbook with several tabs. The first tab is the main page containing all categories. The other tabs are the individual categories. Basically what I do right now is open the workbook that I am sent that contains the updates. The first column in each record contains the category tag. I select all of category "A" and append that to the master list, as well as the tab with category "A" only. I would like to automate the process by which I do this. Any ideas?