Sorting across multiple Sheets

[Bwgreen]

Hi I have a workbook with two sheets. I need to sort ascending on both sheets. So if A is on sheet 2 and Z is on sheet one it would move A to sheet 1 and Z to sheet 2. Both sheets have same formatting. Column B would be the key column and column AL would be the last all rows need to stay intact. The sort would start at row 5 since 1-4 have merged cells and titles in them. If anybody can provide help with this please let me know. Thank you.

[K m]

How about a macro. The macro would do the following:
- Copy both sheets(let's call SHEET1 and SHEET2) to a temporary
worksheet, lets call TEMP
- Sort the data
- Copy the data from the TEMP worksheet back to SHEET1 and SHEET2
- Delete or hide the TEMP worksheet

[Bwgreen]

that would work but I am not sure how to do that. i will research it myself first. first though. I would have replied earlier but i could not find the post anymore I forgot to subscribe to it. Now I did though