what are some ways a manager could use data consolidation in Excel to track sales? For example, a regional manager may collect sales data in Excel from several store locations. This data is formatted the same from each location. How can data consolidation be used? Another option is to put all the data from every location into a single worksheet for analysis. What are the pros and cons of this approach?