How to auto set data source path in power query excel

Hello,

I have a macro excel sheet where i have created  some query datas , when i share the sheet with others they need to change the input data source settings to set the path for the input file. Is there a way to auto set/dynamic path setting tricks available to set the data source path???