vlookup from filename

i have file names as below what i need is if it contains 456 it have to vlookup from master sheet as [TABLE="width: 366"]

[tr]

[td]

C:\Users\123\Desktop\AHK\456.ahk

[/td]

[/tr]

[tr]

[td]

C:\Users\123\Desktop\AHK\789.ahk

[/td]

[/tr]

[tr]

[td]

C:\Users\123\Desktop\AHK\100.ahk

[/td]

[/tr]

[tr]

[td]

C:\Users\123\Desktop\AHK\123.ahk

[/td]

[/tr]

[tr]

[td]

C:\Users\123\Desktop\AHK\2021.ahk

[/td]

[/tr]

[tr]

[td]

C:\Users\123\Desktop\AHK\2022.ahk

master sheet
[TABLE="width: 500"]

[tr]

[td]

[TABLE="width: 109"]

[tr]

[TD="class: xl67, width: 109"]Customer Name

[/tr][/td][tr]

[/tr]

[/TABLE]

[/tr][/td][tr]

[td]

[TABLE="width: 414"]

[tr]

[TD="class: xl67, width: 414"]E-mail and cc's

[/tr][/td][tr]

[/tr]

[/TABLE]
[/TD]

[td]

[TABLE="width: 320"]

[tr]

[TD="class: xl67, width: 320"]CC

[/tr][/td][tr]

[/tr]

[/TABLE]
[/TD]

[/tr]

[tr]

[td]

456

[/td]

[td]

[email protected]

[/td]

[td]

[email protected]
[email protected]
[email protected]
[email protected]
[email protected]

[/td]

[/tr]

[tr]

[td][/td]

[td][/td]

[td][/td]

[/tr]

[/TABLE]

[/TD]

[/tr]

[/TABLE]