Combining Werksheets
 

I have a worksheet that has data from 6 regions. I would like to create tabs
for each region to allow the people to enter the data into the regional tabs,
but I need the data to automatically merge into one tab for the company to
search the data. Or even better, would be to have 6 spreadsheet files, that
can be merged into one spreadsheet.

I am using Excel 2000, is this possible? We are sharing the file on file
sharing site.

Thanks,