Depends on how much data you have in all 12 sheets.
If the grand total is less than or equal to 65536 (number of rows in a
worksheet), then you could add a new worksheet, copy each of the twelve sheets'
data to that new sheet and sort that.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.