To enable automatic updates, simply refresh the Power Query connection to your folder. Excel will scan the folder for any new files and seamlessly integrate them into your existing dataset.