merging sheets

[b166er]

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

 

[m96]

you should first tell us how you want to merge:
1. based on specific criterias across the sheets
2. or just a simple copy and paste all data together
2a. if so based on rows
2b. or based on columns

you need to be more specific....