How about arranging the data in a single table, with columns for State, City, Client, Account, ... and using AutoFilter?