I have a long list of people by location, Fname, Lname, age:
Ohio, Tom, Smith, 12
Indiana, John, Johnson, 5
Ohio, Erica, Thompson, 40
Arizona, James, Simpson, 24

The list is currently in excel and I am frequently adding people to
the list and would like to keep the master list while being able to
see each location on a separate tab. So I want an Ohio tab, an Indiana
tab, and a Arizona tab.

Is there an equation or other way so I only have to add this
information to the master tab and can automatically see it reflected
in the state tab. I am trying to avoid doing double entry workand
using Access. Each state tab has a slightly different format so using
the filter won't work and I also need the master list.

Thanks in advance for the solution.