Return the last 5 results in a column to specified cells

[subtotalatom]

Hello,

i need a formula or code to return the results of the last 5 cells to another cell section (which will be put on the dashboard eventually) as data is inputted. so the last 5 results in column y need to return to (ai, aj, ak, al, am) with the last result on column y being in Cell AM. as data is entered in Column y. the results will move across in AI, AJ, AL, AL, AM

KBJM Bet Club Tracker.xlsx
	T	U	V	W	X	Y									AH	AI	AJ	AK	AL	AM
1	Bet	League	Odds	Stake	SF	W/L
2	Peterbrough	England National League	1.67	£5		W
3	Over 2.5	England League One	2.25	£5	£5	L
4	Lazio	Italy Serie A	1.6	£5		W
5	Leganes	Spain Other	1.6	£5		W
6	Stockport	England National League	1.7	£5		L
7	Cheltenham	England League Two	1.8	£5		W
8	Over 2.5	Italy Serie A	1.65	£5		W
9	Doncaster	England League One	2.63	£5		L
10	Brentford	England Championship	1.53	£5	£5	L
11	Arsenal	England Premier League	1.75	£5		L
12	Over 2.5	France Ligue 1	1.53	£5		L
13	Union Berlin	Germany Bundesliga	1.85	£5		W										MIKE
14	Charlton	England League One	1.62	£5		W
15
16
17
18
19
20
Bet Tracker

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
G10,M10,S10,Y10:Z10	Cell Value	="L"	text	NO
G10,M10,S10,Y10:Z10	Cell Value	="W"	text	NO
G2:G9,M2:M9,S2:S9,Y2:Z9,Y122:Z144,S122:S144,M122:M144,G122:G144,Y76:Z76,S76,M76,G76,Y11:Z31,S11:S31,M11:M31,G11:G31	Cell Value	="L"	text	NO
G2:G9,M2:M9,S2:S9,Y2:Z9,Y122:Z144,S122:S144,M122:M144,G122:G144,Y76:Z76,S76,M76,G76,Y11:Z31,S11:S31,M11:M31,G11:G31	Cell Value	="W"	text	NO

Cells with Data Validation
Cell	Allow	Criteria
U2:U20	List	='KJBM Data'!$A$9:$A$50

 

[Fluff]

How about in AI14

=LET(Fltr,FILTER(Y2:Y100,Y2:Y100<>""),INDEX(Fltr,SEQUENCE(,5,ROWS(Fltr)-4)))

 

[subtotalatom]

Ah youre good. thankyou once again.

 

[Fluff]

Glad to help & thanks for the feedback.