I have 12 sheets in a single workbook. Each sheet represents a county. Within each county are multiple sites (rows) with heading columns describing the site characteristics. Each sheet/county has identical headings. Over time, I add/subtract sites from various counties.
I want to make a summary page (with identical heading columns to the other sheets) that pulls all the data from each site in each county, given that the number of sites in a county is dynamic and I will keep adding/subtracting sites. How would I accomplish this? Thank you for any suggestions!
In the example, I'd like to figure out how to make the summary table automatically show all the sites, even when I change the number of sites in County1 for example.
Bookmarks