You are running a data analysis project using Excel and have a large dataset spread over multiple worksheets. You need to consolidate all this data into one single worksheet. Which of the following methods would be the most efficient way to accomplish this task?
1
Manually copy and paste each data set into a single worksheet.
2
Use the 'VLOOKUP' function to extract and collate the data.
3
Use Excel’s 'Consolidate' tool for merging data from multiple worksheets.
4
Use the 'FILTER' function to select and move the data.