Sort all cells multiple workbooks

Hello,

I have number codes from A1 to EA65000 in multiple workbooks. I would like to order from smallest to biggest number code for all the workbooks.

Is this possible and how?

Ok, can you explain what you mean by sorting should be continues over all the workbooks?

If workbook1 ends with numbercode 1-4-5 and workbook2 starts with 1-4-4 it should be the other way around after sorting.

So workbook1 ends with 1-4-4 and workbook2 starts with 1-4-5.

U guess here you mean sheet by workbook1 or workbook2..

Also what if workbook2 has lesser value then 1-4-5, it should be deleted or ignored?