Power Query - Dynamic Path issue

[Mumba]

Hi All

I am building a Power Query that holds a dynamic Path to a folder that holds my data input files.
I have managed to set it up so that the path is dynamic.
My big issue is that when i change the path I get an error because the sheet selection is based on the static path given before the change.
How do a make this dynamic???

Issues start in the second line holding a #

let
  Source = Excel.CurrentWorkbook(){[Name = "DynamicPath"]}[Content],
  Path = Source{0}[Dynamic Path],
  GetFolderFiles = Folder.Files(Path),
    #"C:\Material_Segmentation\PlantSite Data\_MB51 XLSX" = GetFolderFiles{[#"Folder Path"="C:\Material_Segmentation\PlantSite Data\",Name="MB51.XLSX"]}[Content],
    #"Imported Excel" = Excel.Workbook(#"C:\Material_Segmentation\PlantSite Data\_MB51 XLSX"),
    Sheet1_Sheet = #"Imported Excel"{[Item="Sheet1",Kind="Sheet"]}[Data],