I have a worksheet with the following column headings "name" "region"
"date" "author", there are 4 different regions the data can be from.
I would like to create 4 new worksheets within the same workbook, one
for each region, that takes the data from the main worksheet and sorts
it into one of the four worksheets depending on the region. Is there
a way to do this so that if I add an entry to the main worksheet, the
corresponding region worksheet will automatically update with the new
data?