That was not completely what I meant. Here's how sheet 1 looks now
with two branches:

(sheet 1)

1 D 240102 x 90 200
1 D 240103 y 9787 100
1 D 240107 z 8897 200
1 D 240110 a 45 640

(blank row)
1 S 240229 j 4545 100
1 S 240232 k 544545 200
1 S 240233 l 454556 124
1 S 240238 m 45456 135

(blank row)


This now gets moved to sheet 2 as above but with an additional column
A that has the branch 1 and 2




2 D 240101 x 40 200
2 D 240105 y 87 400
2 D 240107 z 8897 200
2 D 240110 a 45 640

(blank row)
2 S 240229 j 4545 100
2 S 240232 k 544545 200
2 S 240233 l 454556 124
2 S 240240 m 4 35

(blank row)


(sheet 2)
1 D 240101 x 40
200
1 D 240102

1 D 240103 y 9787
100
1 D 240104

1 D 240105

1 D 240106

1 D 240107 z 8897
200
1 D 240108

1 D 240109

1 D 240110 a 45
640
1 D 240111

(blank row)
1 S 240229 j 4545
100
1 S 240230

1 S 240231

1 S 240232 k 544545
200
1 S 240233 l 454556
124
1 S 240234

1 S 240236

1 S 240237

1 S 240238 m 45456
135


2 D 240101

2 D 240102 x 90
200
2 D 240103 y 9787
100
2 D 240104

2 D 240105

2 D 240106

2 D 240107 z 8897
200
2 D 240108

2 D 240109

2 D 240110 a 45
640
2 D 240111

(blank row)
2 S 240229 j 4545
100
2 S 240230

2 S 240231

2 S 240232 k 544545
200
2 S 240233 l 454556
124
2 S 240234

2 S 240236

2 S 240237

2 S 240238 m 45456
135
2 S 240239

2 S 240240 4
35