Copy data from multiple rows until blank then go to the next set of rows until blank

[tomtheappraiser]

I'm not very educated on VBA yet, so I've been trying to make this spreadsheet work with just formulas, but I think I ran into a show stopper for formulas.
So I'm trying to get data from our assessors office website and put it into my Access DB. So first I'm copying it into an excel sheet then converting it to table format then exporting it to Access. I was doing fine until I got the the buildings section. So the website has a separate page for each building called a "Card". There could be up to 50 buildings, but generally there's an average of 5. On each building they break down each section of the building. So I'm copying the card into a sheet and have multiple copies of these card in that one sheet called "Bldgs", next to each other. So I'm trying to extract all of the building section data into one table on a sheet called "ExBldgSec".
My problem is I never know how many buildings I will have, nor the amount of sections each building will have. So I want it to go down the columns of the first set of rows until there is no information, then I want it to go to the second set of columns (the 2nd card) and copy everything through all of the rows until the rows are blank and repeat the process until it to comes to a set of columns that doesn't have anything in it at which time it will stop copying.
I'm uploading the spreadsheet I'm working on.I don't know how to upload the other sheet I want to copy the data to. As noted the data I want to transfer is under the red outlined columns. I want it transferred to the ExBldgImp tab.
Any help you could provide would be much appreciated. If you have any suggestion on a better way to organize that as well, please make a suggestion,
Thanks again for any help

ImportCountyParcelSample.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU
1	TotalSF	TotalBldgs	ConstType	YearsBlt	TotalUnits	UnitType	Zoning	CeilingHt	FinAreaSF
2
3
4
5	Card Number 1												Card Number 2												Card Number 3												Card Number 4
6	Locator Number	Tax Year	Card Number?	Total Living Units									3F540700	Tax Year	Card Number?	Total Living Units
7	13F540700	2021	1	0		TotalSF	7,442							2021	2	0		TotalSF	34,504											TotalSF												TotalSF
8	Year Built:	1960	Number of Units:			PropType:	2						Year Built:	1955	Number of Units:			PropType:	2											PropType:	#N/A											PropType:	#N/A
9	Building Number:?	1	Area Under Roof:	7,442 ft2		SubType							Building Number:?	2	Area Under Roof:	34,504 ft2		SubType	1											SubType	#N/A											SubType	#N/A
10	Structure Type:	RETAIL MULTI OCCUP	Class:?	C									Structure Type:	STRIP SHOPPING CNTR	Class:?	C
11	Grade:?	D-	Identical Units:	1									Grade:?	D-	Identical Units:	1
12	Improvement Name:	VACANT											Improvement Name:	FAITH HOPE MINISTRIES
13
14
15
16	Line	Sect	From	To	Year Built	Total Area?	Peri-	Use Type	Wall Height	Wall Type	Const		Line	Sect	From	To	Year Built	Total Area?	Peri-	Use Type	Wall Height	Wall Type	Const		Line	Sect	From	To	Year Built	Total Area?	Peri-	Use Type	Wall Height	Wall Type	Const		Line	Sect	From	To	Year Built	Total Area?	Peri-	Use Type	Wall Height	Wall Type	Const
17	1	1	B1	B1		3,721 ft2	244	SUPPORT	12 ft	NONE	WOOD FRAME, JOIST AND BEAM		1	1	B1	B1	1955	17,252 ft2	606	RETAIL STORE	12 ft	NONE	WOOD FRAME, JOIST AND BEAM
18	2	1	1	1		3,721 ft2	244	RETAIL STORE	12 ft	BRICK OR STONE VENEER	WOOD FRAME, JOIST AND BEAM		2	1	1	1	1955	17,252 ft2	606	RETAIL STORE	12 ft	BRICK OR STONE VENEER	WOOD FRAME, JOIST AND BEAM
19	3	1	2	2		3,721 ft2	244	MULTI OFFICE	12 ft	BRICK OR STONE VENEER	WOOD FRAME, JOIST AND BEAM
20
21
22
23
24
Bldgs

Cell Formulas
Range	Formula
G7,AQ7,AE7,S7	G7	=IF(D9="","",LEFT(D9,FIND(" ",D9)-1))
G8,AQ8,AE8,S8	G8	=VLOOKUP(B10,Lookup!$L$3:$M$100,2,FALSE)
G9,AQ9,AE9,S9	G9	=IF(VLOOKUP(B10,Lookup!$L$3:$N$100,3,FALSE)="","",VLOOKUP(B10,Lookup!$L$3:$N$100,3,FALSE))