Best way to automate data refresh for multiple power queries pulling from web sources?

Ive got a workbook with about 15 power queries pulling data from different web sources. Some need to refresh daily, others weekly. Right now Im just clicking refresh all manually but its getting tedious. I tried setting up a VBA macro to refresh them on open but it slows down startup a ton. Anyone found a solid way to schedule these refreshes or optimize the process? Considering power automate but not sure if its overkill. Curious how others handle this since my data sources are pretty stable at this point.