"re-import data using current configuration" auto refresh, with multiple excel files

I currently have a Mindmap with 20+ different excel files all linked and I would like to refresh these excel docs on a daily basis as they are constantly being updated. However the only way i can seem to do this is by right clicking each one individually and clicking "re-import data using current configuration".

Is there a way to do this within the software? I have tried to create a macro and keep getting hung up, tried some troubleshooting with Chatgpt but did not result in any good results.

Any ideas on how to automate this?