Need to copy data from multiple sheets into one sheet

[soberoi]

Hi,

I need advice on copying data from multiple sheets into one sheet. The excel sheet is like this where I have 'sheet 1, 2,3, till 20. The data on the sheet has the following columns - Serial No, Inst code, Name, Code,Course,Seats, Total Seats and district".


Need to get all the data into one single sheet so that I can compare and analyse them. Do let me know. Thanks

 

[bobhc]

Good day soberoi


I point you to the answer Deb gave to a post that was posted just after yours


http://chandoo.org/forums/topic/multiple-sheets-in-to-one-sheet