I have an Excel workbook containing 50 worksheets. I need to amalgamate them all into one big worksheet.
Each worksheet contains the same column headings and, say, 20 records. Does anyone know how to pull them into one big worksheet of 20 x 50 = 1000 records?
It would save me an awful lot of cutting and pasting. Thanks in advance.