Sorting data from another sheet to display in a main page

[Gonney]

Hi Team,

This one is a bit complex, I've been working for a bit on it today but nothing seems to work. I am working in Excel 2016.

Ideally I am looking at having two sheets, the first one which is the input sheet which shows the results of the second sheet import.
The import sheet is data I pull from another source and then paste it into the sheet, this can be a lot of data and there is always a lot of holes in the data.
I'm looking for the A:Z to be where reference number is found.
Once the reference number is found i'm looking to have it find the first none blank cell and then display the date in the "Start date" area.

Example: Number 1223 in B1, first none blank cell is in B5 and the date is in A5. for this to display on the start date area.

I'm then looking to have the "load" display for this based on the above and then the following loads to all display below it. I have flagged the example in yellow.

Input sheet:

load.xlsx
	D	E	F	G	H	I	J	K
1	Using the enter number as a referance
2	Start Date:	Find the first date with usage from the import sheet and display it here
3	Load: find the load from this date referance point and display it
4
5	Enter Number	1223		Enter Number	15897		Enter Number	1234
6	Start date			Start date			Start date
7
8
9
10
11
12
13	Date	load		Date	load		Date	load
14	-			-			-
15
16
17
18
19	Example
20	Enter Number	1223
21	Start date	1/01/2023
22
23
24
25
26
27
28	Date	load
29	1/01/2023	12
30	1/01/2023	1233
31	1/01/2023	441
32	1/01/2023	346
33	1/01/2023	2346
34	1/01/2023	34578
35	1/01/2023	34553
36	1/01/2023	667
37	1/01/2023	890
Input

Cell Formulas
Range	Formula
E5	E5	=Import!B1
H5	H5	=Import!C1
K5	K5	=Import!D1
D14,J14,G14	D14	=IF(E6="","-",E6)
E20	E20	=Import!B1
E21	E21	=Import!A5

Import sheet:

load.xlsx
	A	B	C	D
1	Date and Time	1223	15897	1234
2	1/01/2023 0:00
3	1/01/2023 0:30			234
4	1/01/2023 1:00			45
5	1/01/2023 1:30	12		6
6	1/01/2023 2:00	1233		441
7	1/01/2023 2:30	441		3
8	1/01/2023 3:00	346		1233
9	1/01/2023 3:30	2346		55
10	1/01/2023 4:00	34578		676
11	1/01/2023 4:30	34553		7765
12	1/01/2023 5:00	667		456
13	1/01/2023 5:30	890		345
14	2/01/2023 0:00		1
15	2/01/2023 0:30		23
16	2/01/2023 1:00		43
17	2/01/2023 1:30		322
18	2/01/2023 2:00		3465
19	2/01/2023 2:30	346	654	55
20	2/01/2023 3:00	2346	542	676
21	2/01/2023 3:30	34578	234	7765
22	2/01/2023 4:00	34553		456
23	2/01/2023 4:30	667		345
24	2/01/2023 5:00
25	2/01/2023 5:30
Import