What are the steps for consolidating data from multiple worksheets? 1. Select the range of data on the first worksheet you wish to consolidate. 2. Go to the Data tab on the ribbon and select Data Tools. 3. Then, select and the dialog box will appear. 4. Choose the in the drop-down. Then, select the first group of data and press Enter. 5. To add from more worksheets, select from the View tab. 6. To include more references, click .