Excel Hack 65: Consolidate data from several Excel workbooks into one worksheet
This is a common scenario. As a data analyst, you have created an Excel template for collating data (for instance, weekly sales records by state), and you have sent it to five other analysts in your organization for their input. They send their input – each in a new workbook! And now, you have to