When confronted with data scattered across multiple workbooks and worksheets, the first step is to consolidate it in a unified format. There are a number of ways to do this, and Nabil Mourad demonstrates several methods that can be applied to scenarios of varying complexity.