Open a blank sheet, go to data tab, select consolidate. A dialogue box will pop out, click the browse button, select your January file. I presume that you have headers in your files so check the "row headers", click "add". Repeat the same process until the last sheet that you want to add in the consolidated data. To make the consolidation process easier, remove all merged cells.
|