Using Excel 2003, please guide me (or tell me it can't be done) concerning
something I am trying to accomplish. I have a workbook with four worksheets.
They are named Main, West, Middle and East. People enter records on West,
Middle and East. I want these same records to show up on the Main sheet so
that sorting and analysis can be done. They don't add data on the Main
sheet. So, for example I have



West

West #1 Record01 Name Address

West #2 Record02 Name Address



East

East #1 Record01 Name Address

East #2 Record02 Name Address

East #3 Record03 Name Address

East #4 Record04 Name Address



Middle

Middle #1 Record01 Name Address

Middle #2 Record02 Name Address

Middle #3 Record03 Name Address



What I would end with on the Main sheet is:



West #1 Record01 Name Address

West #2 Record02 Name Address

East #1 Record01 Name Address

East #2 Record02 Name Address

East #3 Record03 Name Address

East #4 Record04 Name Address

Middle #1 Record01 Name Address

Middle #2 Record02 Name Address

Middle #3 Record03 Name Address



Then if anyone adds anything to one of the work sheets it will automatically
show up on the Main worksheet as the next one on the list. Main is just a
compiled view of the others and should be protected from being changed -
other than to sort and filter. Can this been done and if so, can you direct
me to instructions as to how to set this up? Thanks.



Steve