I would use the combined worksheet for data entry. Then recreate the other
sheets when you need to.

You may want to look at the way Ron de Bruin and Debra Dalgleish approached it:

Ron de Bruin's EasyFilter addin:
http://www.rondebruin.nl/easyfilter.htm

Code from Debra Dalgleish's site:
http://www.contextures.com/excelfiles.html

Create New Sheets from Filtered List -- uses an Advanced Filter to create
separate sheet of orders for each sales rep visible in a filtered list; macro
automates the filter. AdvFilterRepFiltered.xls 35 kb

Update Sheets from Master -- uses an Advanced Filter to send data from
Master sheet to individual worksheets -- replaces old data with current.
AdvFilterCity.xls 55 kb

wrote:

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?

--

Dave Peterson