Capturing Data from a Live sharepoint dashboard

[Stef9910]

Hello all,

I have a live dashboard on SharePoint that gets updated daily or when a job is completed, I would like to capture the data from the live dashboard on another sheet within the workbook as it is entered.
The problem i have is as soon as the live dashboard is updated, the old data is lost.
I have absolutely no idea how to do this.
When new data is input on the live dashboard, i would like it to be replicated in the capture sheet on a new row so the old data is there also.

I can replicate the data on the capture sheet using =IF(ISBLANK('Job Board Live'!A2), "", 'Job Board Live'!A2) but don't know how to make it drop down a row for the new data.

The below is the Job Board Live,

Job Board Live.xlsx
	A	B	C	D	E	F	G	H	I	J
1	Job #	Customer Phone #	Customer	Urgency	Location	Estimated Days	Notes	Receival Date	Start	Completed
2	1	012345678	Harding	MED	Body Shop	1	Needed COB Thurs	6.7.23 10:30	6.7.23 09:25	7.7.23 06:30
3	2	012345679	RM	MED	Dock	1		6.7.23 07:30	6.7.23 07:14
4	3	012345680	Axo	MAX	Dock	1		2.7.23 20:40	5.7.23 15:59
5	4	012345681	JP Bearings	MED	Bench 3	2		4.7.23 15:01	4.7.23 20:30
6	5
7	6
8	7
9	8
10	9
11	10
Job Board Live

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
D2:D11	Cell Value	contains "MIN"	text	NO
D2:D11	Cell Value	contains "MED"	text	NO
D2:D11	Cell Value	contains "MAX"	text	NO

The below is the captured data sheet,

Job Board Live.xlsx
	A	B	C	D	E	F	G	H	I	J
1	Job #	Customer Phone #	Customer	Urgency	Location	Estimated Days	Notes	Receival Date	Start	Completed
2	1	012345678	Harding	MED	Body Shop	1	Needed COB Thurs	6.7.23 10:30	6.7.23 09:25	7.7.23 06:30
3	2	012345679	RM	MED	Dock	1		6.7.23 07:30	6.7.23 07:14
4	3	012345680	Axo	MAX	Dock	1		2.7.23 20:40	5.7.23 15:59
5	4	012345681	JP Bearings	MED	Bench 3	2		4.7.23 15:01	4.7.23 20:30
6	5
7	6
8	7
9	8
10	9
11	10
captured data

Cell Formulas
Range	Formula
A2:J11	A2	=IF(ISBLANK('Job Board Live'!A2), "", 'Job Board Live'!A2)

I hope the above makes sense, ideally i would like to work with a formula and not use VBA.

Any help will greatly appreciated,

Thank you