Ammortization VBA

[ferr]

need to create a macro that essentially does the calculations in the 180 tables (60 tables in A1, 60 in A2 and 60 in A3) into a consolidated table like the one in sheet 7.
Sheet 7 is currently a bunch of queries that appends all the 180 tables into 1 table. I need a macro that does that, so there is no need for the 3 tabs (A1, A2, A3) and no more need for the queries.
Also, if the macro can exclude any data where the beginning balance is 0.

Schedule 2.xlsx
	A	B	C	D	E	F	G	H
1	Asatdat	Period	Seller name id	Total Beg Balance	Total Interest	Total Prepayments	Total End Balance	AssetCAtegory_broad
2	7/31/22 0:00	1	7	-	-	0	-	CREM
3	8/31/22 0:00	2	7	-	-	0	-	CREM
4	9/30/22 0:00	3	7	-	-	0	-	CREM
5	10/31/22 0:00	4	7	-	-	0	-	CREM
6	11/30/22 0:00	5	7	-	-	0	-	CREM
7	12/31/22 0:00	6	7	-	-	0	-	CREM
8	1/31/23 0:00	7	7	-	-	0	-	CREM
9	2/28/23 0:00	8	7	-	-	0	-	CREM
10	3/31/23 0:00	9	7	-	-	0	-	CREM
11	4/30/23 0:00	10	7	-	-	0	-	CREM
12	5/31/23 0:00	11	7	-	-	0	-	CREM
13	6/30/23 0:00	12	7	-	-	0	-	CREM
14	7/31/23 0:00	13	7	-	-	0	-	CREM
15	8/31/23 0:00	14	7	500,000.00	1,756.40	0	500,000.00	CREM
16	9/30/23 0:00	15	7	1,000,000.00	5,128.10	0	1,000,000.00	CREM
17	10/31/23 0:00	16	7	1,500,000.00	8,817.25	0	1,500,000.00	CREM
18	11/30/23 0:00	17	7	2,000,000.00	11,921.90	0	2,000,000.00	CREM
19	12/31/23 0:00	18	7	2,500,000.00	15,872.03	0	2,500,000.00	CREM
20	1/31/24 0:00	19	7	3,000,000.00	19,460.36	0	3,000,000.00	CREM
21	2/29/24 0:00	20	7	3,500,000.00	21,488.54	0	3,500,000.00	CREM
22	3/31/24 0:00	21	7	4,000,000.00	26,267.98	0	4,000,000.00	CREM
23	4/30/24 0:00	22	7	4,500,000.00	28,392.57	0	4,500,000.00	CREM
24	5/31/24 0:00	23	7	5,000,000.00	32,276.50	0	5,000,000.00	CREM
25	6/30/24 0:00	24	7	5,500,000.00	34,050.48	0	5,500,000.00	CREM
26	7/31/24 0:00	25	7	6,000,000.00	38,044.48	0	6,000,000.00	CREM
27	8/31/24 0:00	26	7	6,500,000.00	40,743.86	0	6,500,000.00	CREM
28	9/30/24 0:00	27	7	7,000,000.00	41,814.12	0	7,000,000.00	CREM
29	10/31/24 0:00	28	7	7,500,000.00	45,438.76	0	7,500,000.00	CREM
30	11/30/24 0:00	29	7	8,000,000.00	45,971.72	0	8,000,000.00	CREM
31	12/31/24 0:00	30	7	8,500,000.00	49,472.25	0	8,500,000.00	CREM
32	1/31/25 0:00	31	7	9,000,000.00	51,338.32	0	9,000,000.00	CREM
33	2/28/25 0:00	32	7	9,500,000.00	48,019.54	0	9,500,000.00	CREM
34	3/31/25 0:00	33	7	10,000,000.00	54,913.91	0	10,000,000.00	CREM
35	4/30/25 0:00	34	7	10,500,000.00	54,831.21	0	10,500,000.00	CREM
36	5/31/25 0:00	35	7	11,000,000.00	58,608.52	0	11,000,000.00	CREM
37	6/30/25 0:00	36	7	11,500,000.00	58,875.82	0	11,500,000.00	CREM
38	7/31/25 0:00	37	7	12,000,000.00	63,060.45	0	11,500,000.00	CREM
39	8/31/25 0:00	38	7	12,000,000.00	62,136.28	0	11,500,000.00	CREM
40	9/30/25 0:00	39	7	12,000,000.00	58,618.29	0	11,500,000.00	CREM
41	10/31/25 0:00	40	7	12,000,000.00	58,821.36	0	11,500,000.00	CREM
42	11/30/25 0:00	41	7	12,000,000.00	55,706.95	0	11,500,000.00	CREM
43	12/31/25 0:00	42	7	12,000,000.00	57,247.02	0	11,500,000.00	CREM
44	1/31/26 0:00	43	7	12,000,000.00	57,572.10	0	11,500,000.00	CREM
45	2/28/26 0:00	44	7	12,000,000.00	52,366.54	0	11,500,000.00	CREM
46	3/31/26 0:00	45	7	12,000,000.00	58,102.46	0	11,500,000.00	CREM
47	4/30/26 0:00	46	7	12,000,000.00	56,126.15	0	11,500,000.00	CREM
48	5/31/26 0:00	47	7	12,000,000.00	57,846.92	0	11,500,000.00	CREM
49	6/30/26 0:00	48	7	12,000,000.00	55,935.15	0	11,500,000.00	CREM
50	7/31/26 0:00	49	7	12,000,000.00	57,839.06	0	11,500,000.00	CREM
51	8/31/26 0:00	50	7	12,000,000.00	57,893.98	0	11,500,000.00	CREM
52	9/30/26 0:00	51	7	12,000,000.00	56,042.30	0	11,500,000.00	CREM
53	10/31/26 0:00	52	7	12,000,000.00	57,895.86	0	11,500,000.00	CREM
54	11/30/26 0:00	53	7	11,500,000.00	54,817.55	0	11,000,000.00	CREM
55	12/31/26 0:00	54	7	11,000,000.00	54,176.40	0	10,500,000.00	CREM
56	1/31/27 0:00	55	7	10,500,000.00	51,718.60	0	10,000,000.00	CREM
57	2/28/27 0:00	56	7	10,000,000.00	44,494.41	0	9,500,000.00	CREM
58	3/31/27 0:00	57	7	9,500,000.00	46,800.31	0	9,000,000.00	CREM
59	4/30/27 0:00	58	7	9,000,000.00	42,905.58	0	8,500,000.00	CREM
60	5/31/27 0:00	59	7	8,500,000.00	41,870.81	0	8,000,000.00	CREM
61	6/30/27 0:00	60	7	8,000,000.00	38,136.08	0	7,500,000.00	CREM
62	7/31/22 0:00	1	6	-	-	0	-	CREM
63	8/31/22 0:00	2	6	-	-	0	-	CREM
64	9/30/22 0:00	3	6	-	-	0	-	CREM
65	10/31/22 0:00	4	6	-	-	0	-	CREM
66	11/30/22 0:00	5	6	-	-	0	-	CREM
67	12/31/22 0:00	6	6	-	-	0	-	CREM
68	1/31/23 0:00	7	6	-	-	0	-	CREM
69	2/28/23 0:00	8	6	-	-	0	-	CREM
70	3/31/23 0:00	9	6	-	-	0	-	CREM
71	4/30/23 0:00	10	6	-	-	0	-	CREM
72	5/31/23 0:00	11	6	-	-	0	-	CREM
73	6/30/23 0:00	12	6	-	-	0	-	CREM
74	7/31/23 0:00	13	6	-	-	0	-	CREM
75	8/31/23 0:00	14	6	600,000.00	2,184.12	0	600,000.00	CREM
76	9/30/23 0:00	15	6	1,110,000.00	6,056.86	0	1,110,000.00	CREM
77	10/31/23 0:00	16	6	2,110,000.00	11,766.84	0	2,110,000.00	CREM
78	11/30/23 0:00	17	6	2,710,000.00	17,012.41	0	2,710,000.00	CREM
79	12/31/23 0:00	18	6	3,310,000.00	22,000.17	0	3,310,000.00	CREM
80	1/31/24 0:00	19	6	3,910,000.00	26,465.96	0	3,910,000.00	CREM
81	2/29/24 0:00	20	6	4,510,000.00	28,839.41	0	4,510,000.00	CREM
82	3/31/24 0:00	21	6	5,110,000.00	34,918.63	0	5,110,000.00	CREM
83	4/30/24 0:00	22	6	5,710,000.00	37,476.04	0	5,710,000.00	CREM
84	5/31/24 0:00	23	6	6,310,000.00	42,369.58	0	6,310,000.00	CREM
85	6/30/24 0:00	24	6	6,910,000.00	44,501.03	0	6,910,000.00	CREM
86	7/31/24 0:00	25	6	7,510,000.00	49,541.53	0	7,510,000.00	CREM
87	8/31/24 0:00	26	6	8,110,000.00	52,903.48	0	8,110,000.00	CREM
88	9/30/24 0:00	27	6	8,710,000.00	54,170.99	0	8,710,000.00	CREM
89	10/31/24 0:00	28	6	9,310,000.00	58,765.11	0	9,310,000.00	CREM
90	11/30/24 0:00	29	6	9,910,000.00	59,374.52	0	9,910,000.00	CREM
91	12/31/24 0:00	30	6	10,510,000.00	63,827.11	0	10,510,000.00	CREM
92	1/31/25 0:00	31	6	11,110,000.00	66,179.16	0	11,110,000.00	CREM
93	2/28/25 0:00	32	6	11,710,000.00	61,858.61	0	11,710,000.00	CREM
94	3/31/25 0:00	33	6	12,310,000.00	70,702.76	0	12,310,000.00	CREM
95	4/30/25 0:00	34	6	12,910,000.00	70,565.08	0	12,910,000.00	CREM
96	5/31/25 0:00	35	6	13,510,000.00	75,386.17	0	13,510,000.00	CREM
97	6/30/25 0:00	36	6	14,110,000.00	75,678.54	0	14,110,000.00	CREM
98	7/31/25 0:00	37	6	14,710,000.00	81,007.84	0	14,710,000.00	CREM
99	8/31/25 0:00	38	6	15,310,000.00	83,200.26	0	15,310,000.00	CREM
100	9/30/25 0:00	39	6	15,910,000.00	81,724.06	0	15,910,000.00	CREM
101	10/31/25 0:00	40	6	16,510,000.00	85,278.67	0	16,510,000.00	CREM
102	11/30/25 0:00	41	6	17,110,000.00	83,841.43	0	17,110,000.00	CREM
103	12/31/25 0:00	42	6	17,710,000.00	89,259.01	0	17,710,000.00	CREM
104	1/31/26 0:00	43	6	18,310,000.00	92,833.41	0	18,310,000.00	CREM
105	2/28/26 0:00	44	6	18,910,000.00	87,222.53	0	18,910,000.00	CREM
106	3/31/26 0:00	45	6	19,510,000.00	99,885.94	0	19,510,000.00	CREM
107	4/30/26 0:00	46	6	20,110,000.00	99,510.95	0	20,110,000.00	CREM
108	5/31/26 0:00	47	6	20,710,000.00	105,681.69	0	20,710,000.00	CREM
109	6/30/26 0:00	48	6	21,310,000.00	105,197.35	0	21,310,000.00	CREM
110	7/31/26 0:00	49	6	21,910,000.00	111,880.76	0	21,310,000.00	CREM
111	8/31/26 0:00	50	6	21,910,000.00	111,981.76	0	21,400,000.00	CREM
112	9/30/26 0:00	51	6	22,000,000.00	108,850.08	0	21,000,000.00	CREM
113	10/31/26 0:00	52	6	21,600,000.00	110,378.77	0	21,000,000.00	CREM
114	11/30/26 0:00	53	6	21,000,000.00	105,279.70	0	20,400,000.00	CREM
115	12/31/26 0:00	54	6	20,400,000.00	105,670.41	0	19,800,000.00	CREM
116	1/31/27 0:00	55	6	19,800,000.00	102,571.43	0	19,200,000.00	CREM
117	2/28/27 0:00	56	6	19,200,000.00	89,847.89	0	18,600,000.00	CREM
118	3/31/27 0:00	57	6	18,600,000.00	96,369.26	0	18,000,000.00	CREM
119	4/30/27 0:00	58	6	18,000,000.00	90,249.51	0	17,400,000.00	CREM
120	5/31/27 0:00	59	6	17,400,000.00	90,145.45	0	16,800,000.00	CREM
121	6/30/27 0:00	60	6	16,800,000.00	84,228.22	0	16,200,000.00	CREM
122	7/31/22 0:00	1	4	-	-	0	-	CREM
123	8/31/22 0:00	2	4	-	-	0	-	CREM
124	9/30/22 0:00	3	4	-	-	0	-	CREM
125	10/31/22 0:00	4	4	-	-	0	-	CREM
126	11/30/22 0:00	5	4	-	-	0	-	CREM
127	12/31/22 0:00	6	4	-	-	0	-	CREM
128	1/31/23 0:00	7	4	-	-	0	-	CREM
129	2/28/23 0:00	8	4	-	-	0	-	CREM
130	3/31/23 0:00	9	4	-	-	0	-	CREM
131	4/30/23 0:00	10	4	-	-	0	-	CREM
132	5/31/23 0:00	11	4	-	-	0	-	CREM
133	6/30/23 0:00	12	4	-	-	0	-	CREM
134	7/31/23 0:00	13	4	-	-	0	-	CREM
135	8/31/23 0:00	14	4	2,000,000.00	7,110.53	0	2,000,000.00	CREM
136	9/30/23 0:00	15	4	3,000,000.00	17,299.15	0	3,000,000.00	CREM
137	10/31/23 0:00	16	4	4,000,000.00	24,985.56	0	4,000,000.00	CREM
138	11/30/23 0:00	17	4	6,000,000.00	34,473.53	0	6,000,000.00	CREM
139	12/31/23 0:00	18	4	8,000,000.00	49,974.16	0	8,000,000.00	CREM
140	1/31/24 0:00	19	4	10,000,000.00	64,452.85	0	10,000,000.00	CREM
141	2/29/24 0:00	20	4	12,000,000.00	73,604.42	0	12,000,000.00	CREM
142	3/31/24 0:00	21	4	14,000,000.00	92,166.45	0	14,000,000.00	CREM
143	4/30/24 0:00	22	4	16,000,000.00	101,441.94	0	16,000,000.00	CREM
144	5/31/24 0:00	23	4	18,000,000.00	116,959.72	0	18,000,000.00	CREM
145	6/30/24 0:00	24	4	20,000,000.00	124,791.94	0	20,000,000.00	CREM
146	7/31/24 0:00	25	4	22,000,000.00	140,728.61	0	22,000,000.00	CREM
147	8/31/24 0:00	26	4	24,000,000.00	151,890.84	0	24,000,000.00	CREM
148	9/30/24 0:00	27	4	26,000,000.00	156,921.89	0	26,000,000.00	CREM
149	10/31/24 0:00	28	4	28,000,000.00	171,513.36	0	28,000,000.00	CREM
150	11/30/24 0:00	29	4	30,000,000.00	174,406.77	0	30,000,000.00	CREM
151	12/31/24 0:00	30	4	32,000,000.00	188,528.60	0	32,000,000.00	CREM
152	1/31/25 0:00	31	4	34,000,000.00	196,421.55	0	34,000,000.00	CREM
153	2/28/25 0:00	32	4	36,000,000.00	184,380.47	0	36,000,000.00	CREM
154	3/31/25 0:00	33	4	38,000,000.00	211,533.73	0	38,000,000.00	CREM
155	4/30/25 0:00	34	4	40,000,000.00	211,831.56	0	40,000,000.00	CREM
156	5/31/25 0:00	35	4	42,000,000.00	227,012.38	0	42,000,000.00	CREM
157	6/30/25 0:00	36	4	44,000,000.00	228,570.71	0	44,000,000.00	CREM
158	7/31/25 0:00	37	4	46,000,000.00	245,330.00	0	44,000,000.00	CREM
159	8/31/25 0:00	38	4	46,000,000.00	241,790.67	0	45,000,000.00	CREM
160	9/30/25 0:00	39	4	47,000,000.00	233,265.18	0	46,000,000.00	CREM
161	10/31/25 0:00	40	4	48,000,000.00	239,277.24	0	46,000,000.00	CREM
162	11/30/25 0:00	41	4	48,000,000.00	226,690.83	0	46,000,000.00	CREM
163	12/31/25 0:00	42	4	48,000,000.00	232,979.88	0	46,000,000.00	CREM
164	1/31/26 0:00	43	4	48,000,000.00	234,280.20	0	46,000,000.00	CREM
165	2/28/26 0:00	44	4	48,000,000.00	213,071.63	0	46,000,000.00	CREM
166	3/31/26 0:00	45	4	48,000,000.00	236,401.60	0	46,000,000.00	CREM
167	4/30/26 0:00	46	4	48,000,000.00	228,367.60	0	46,000,000.00	CREM
168	5/31/26 0:00	47	4	48,000,000.00	235,379.48	0	46,000,000.00	CREM
169	6/30/26 0:00	48	4	48,000,000.00	227,603.61	0	46,000,000.00	CREM
170	7/31/26 0:00	49	4	48,000,000.00	235,348.04	0	46,000,000.00	CREM
171	8/31/26 0:00	50	4	48,000,000.00	235,567.70	0	46,000,000.00	CREM
172	9/30/26 0:00	51	4	48,000,000.00	228,032.21	0	46,000,000.00	CREM
173	10/31/26 0:00	52	4	48,000,000.00	235,575.22	0	46,000,000.00	CREM
174	11/30/26 0:00	53	4	46,000,000.00	223,051.02	0	44,000,000.00	CREM
175	12/31/26 0:00	54	4	44,000,000.00	220,442.59	0	42,000,000.00	CREM
176	1/31/27 0:00	55	4	42,000,000.00	210,441.51	0	40,000,000.00	CREM
177	2/28/27 0:00	56	4	40,000,000.00	181,046.12	0	38,000,000.00	CREM
178	3/31/27 0:00	57	4	38,000,000.00	190,428.65	0	36,000,000.00	CREM
179	4/30/27 0:00	58	4	36,000,000.00	174,581.22	0	34,000,000.00	CREM
180	5/31/27 0:00	59	4	34,000,000.00	170,370.93	0	32,000,000.00	CREM
181	6/30/27 0:00	60	4	32,000,000.00	155,174.44	0	30,000,000.00	CREM
Sheet7