Automatically linking pictures to changing values

[davestephsamem]

Hi,
I'm attempting to create timetables for a school with students with autism - and it helps if they have picture prompts in their handouts. I've got the individual class timetables linked to a master timetable and that's fine: things update when the master timetable is changed. However, I'm not sure how to get the linked pictures to change when the master timetable changes...

2023 timetable with 4 groups in years 7 9 and 10 pictures.xlsx
	A	B
1	Subject	Icon
2	Art
3	Careers
4	Computing
5	DT
6	English
7	Food Tech
8	History
9	LBS
10	Maths
11	Music
12	OL
13	PE
14	Science
Pictures

There are pictures in columnB that don't seem to show up in xl2bb. I'm using a formula defined as PictureLookUp which is =INDEX(Pictures!$B$2:$B$14,MATCH('10Br'!$B$3,Pictures!$A$2:$A$14,0)) but I think I'm out of my depth - I'm trying to autogenerate the pictures on a number of tabs for different classes, such as this 10Br one:...

2023 timetable with 4 groups in years 7 9 and 10 pictures.xlsx
	A	B	C	D	E	F	G	H
1	CLASS TIMETABLE YEAR 10Br SEPTEMBER 2022
2		1	2	3	4	5	6	7
3	Monday	Maths	PSHE	Science	History	English	Maths	English
4		NewM	HH	TD	OS	DB	NewM	DB
5		0	0		0	0	0	0
6
10Br

Cell Formulas
Range	Formula
B3:B4	B3	=Master!Q2
C3:C4	C3	=Master!Q4
D3:D4	D3	=Master!Q6
E3:E4	E3	=Master!Q8
F3:F4	F3	=Master!Q10
G3:G4	G3	=Master!Q12
H3:H4	H3	=Master!Q14
E5:H5,B5:C5	E5	=PictureLookUp

Named Ranges
Name	Refers To	Cells
PictureLookUp	=INDEX(Pictures!$B$2:$B$14,MATCH('10Br'!$B$3,Pictures!$A$2:$A$14,0))	B5:C5, E5:H5

Any help/ideas gratefully received...
Thanks
Dave