Yes can be done, need to get all the rectangs, get the sheet number and sort a list based on that. Ok are the layouts a FIT or true scale as the layout "1" the scale looked odd I work metric also so not sure what is going on
It looks like you have drawn it all to some weird scale, which is not helping why wouldn't the drawing reflect true size, for me text would be say 2.5mm high in a metric dwg but your text is all over the place. I have auto layouts, so asking a few questions to try and help.
There is another post maybe by you that has asked to window a few objects and make a layout to suit, for me that would mean setting the title block to be used, now more questions your title block is labelled as a A1 and appears to be at 1:1 which is good 741mm, given drafting practice all 9 views would fit on a A1 sheet with readability not a problem. The text being around 2.5mm high. If you want 9 sheets then a A4 would be about right size for std details, something I know about publishing to any engineers requiring our standard dwg's online.
You need to confirm your title block size or sizes then can work something out.
