I want to lookup data in other sheets and put them each in a seperate row in the same col

Hello Everyone,

I wanted to ask if a certain Excel task can be done with normal functions or it must be done with VBA

I want in this sheet to write in cell B2 to Check the value in A2 and finds any similar value in Column L in both "Sponsors" and "School" Sheet and return the value of the corresponding cell in column Q in either sheets and if the cell in column Q is empty then take the corresponding value in column P and if there are multiple values for the same entry(value in column A) then i want it to be placed each in a seperate row in the same column that i will type the function in.

P.S: I've attached the Excel file

Hopefully you can help me,
Thanks!

2023 Sponsor data (4) (1) (2).xlsx