How can i merge excel worksheets into one master worksheet?

I have an excel file with multiple worksheets. I want to take all the data from each worksheet and copy it into a master. I have tried using the consolidate feature but it doesnt work or I am not doing it correctly. There are no more than 5 columns with data but some rows do not use all 5 columns and that is ok... show more I have an excel file with multiple worksheets. I want to take all the data from each worksheet and copy it into a master. I have tried using the consolidate feature but it doesnt work or I am not doing it correctly. There are no more than 5 columns with data but some rows do not use all 5 columns and that is ok since i will edit it later. I just simply want to merge all the data so i dont have to edit each worksheet.
7 answers 7