Combining Data from Multiple Sheets into one file
![data table data table](../wp-content/easy-excel/Multiple_Sheets/data table.png)
![data consolidate data consolidate](../wp-content/easy-excel/Multiple_Sheets/data consolidate.png)
3. Click on spreadsheet (sheet1).
4. Mark all the data (1), and then click expand (2).
5. Click Add.
Note: repeat step 2 – 4 for the other spreadsheets. Then remember to check on where you would like to have the labels. You should also make sure that the spreadsheet you are following these steps on is empty.
Template
You can download the Template here – Download
Further reading: Basic concepts Getting started with Excel Cell References