I have an excel document with lots of sheets named city1, city2 etc. The data for each city has the same cell. Population is in city1!B3, city2!B3 etc. I have 10 other variables on each sheet that I need to copy and they are not next each other.
How can I copy this data onto one sheet easily?