Need unattended "Workbook Links" refresh all

With apologies to everyone, I thought one of a dozen different VBA versions would continue working afer I announced I had it working.  Nope!  Please ignore any of my VBA / Macro replies.

I finally asked copilot for a different solution because everything previously given to me by copilot (and all other web research) always eventully failed.

So copilot taught me about power queries, which other responses and research gave as solutions, but at the time I was not ready to go off into new territory.  This time I tackled the query solution and it has been woking flawlessly all day.  I even installed it without users noticing the difference except that all the data is now being automatically updated instead of waiting for my next Date / Workbook Links / Refresh All.  That old way was a pain and is now obsolete.   

Hooray!🤩