Choose source dynamically

I am building a system for managers to track employee performance. Each company has a different Google sheet on a different path. Is there a way to load a sheet dynamically (based on the company name) each time?