This is very much attempt 1, I tested on the L11-core wall dwg. you go to layout All then appload the lisp. it will create layouts 1 2 3 etc, we can work on what to call them next version. Please give it a try. Tested on your new sample dwg also.
;https://forums.autodesk.com/t5/visual-lisp-autolisp-and-general/how-to-split-multiple-sheets-in-one-layout-to-individual-layout/td-p/13032412
; copy layouts by AlanH Sept 2024
(defun c:copylays ( / oldsnap ss clay obj xsc ysc pt1 pt2 bname ins )
(setq oldsnap (getvar 'osmode))
(setvar 'osmode 0)
(setq ss (ssget "X" (list (cons 0 "Insert")(cons 2 "TITLE BLOCK*")(cons 410 (getvar 'ctab)))))
(if (= lay nil)(setq lay 1))
(setq laynew (getint (strcat "\nlayout number " (rtos lay 2 0) " ") ))
(IF (= LAYNEW NIL)
(PRINC)
(setq lay laynew)
)
(setq clay (getvar 'ctab))
(repeat (setq K (sslength ss))
(setq obj (vlax-ename->vla-object (ssname ss (setq k (- K 1)))))
(setq xsc (vlax-get obj 'XScaleFactor))
(setq ysc (vlax-get obj 'yScaleFactor))
(setq ins (vlax-get obj 'insertionpoint))
(setq bname (vlax-get obj 'name))
(cond
((= bname "TITLE BLOCK_A2_R")(setq x 595 y 421))
)
(setq pt1 (mapcar '+ ins (list -8 -8 0.0)))
(setq pt2 (mapcar '+ ins (list X y 0)))
(command "copyclip" "w" pt1 pt2 "")
(command "layout" "n" (rtos lay 2 0))
(setvar 'ctab (rtos lay 2 0))
(command "erase" (ssget "X" (list (cons 0 "viewport")(cons 410 (getvar 'ctab)))) "")
(command "pasteclip" "0,0")
(setq lay (1+ lay))
(setvar 'ctab clay)
)
(setvar 'osmode oldsnap)
(princ)
)
Ps found 1 little bug which I will fix need to move the title block so 0,0 is correct.

Possibly can look at layout name and read numbers will look at that. 16-33 Elev.