Get data from dropdown menu from google sheet cell

[issam.sidaoui]

trying to read data from a dynamic Google sheet. any solution or anyone worked in something similar. thank you guys