If you do not want a macro then "automatic" is out unless Excel has a
built-in feature to filter rows with "Central" in a field named "[region]".
Sadly the designers overlooked this feature<g.

So manually (but still better than copy/pasting each record), select a cell
in your table and do a Data, Filter, AutoFilter. Click the dropdown for the
[region] column and select Central. Then only rows with that item will be
visible. You can then copy them to the other sheet.

--
Jim Rech
Excel MVP