hi membes

how can i merge the data of 15 different worksheets into single sheet in the same workbook data is almost of 5000 rows in each workbook