How do I erase the "Transform File from ..." Folders?

While they are referenced, you can't delete them. The only way is to modify the function or to create a new custom function that does the same thing.

https://www.youtube.com/watch?v=6cGou1-1FOo

Pat

Random_Number please see query dependencies before deleting anything..... 

Go to your main query and delete the Invoke Custom Function step. Then you can delete the Transform files.

--Nate

If you're doing something simple enough, the tips at https://exceleratorbi.com.au/combine-all-sheets-in-a-workbook-with-power-query/ may be helpful. The main idea is: "Copy the code from the advanced editor into a text editor like notepad to save for reuse, and then rebuild your query manually using methods that don't generate the helper queries like "click on binary and then replace the filename reference with a relative reference like {0}" and/or defining a custom function"

(For "grabbing the latest version of a file", I prefer to filter "Date Modified by latest" rather than sort by date, but it seems either can work.)

If your filenames are stable, you can also probably merge the helper queries with the regular ones, but that may be a pain depending on details.