Refresh each excel sheet 1-by-1 using Macro/VBA

Hello All,

I have 100 sheets in my excel, and I can't run Refresh All, as it gives me error "[Microsoft] [ODBC Excel Driver] Too many client tasks."
So currently I have to go to each sheet and click "Refresh" button manually after 5-10 seconds delay.
How can I automate "Refresh" on all sheets by clicking one button with 5-10 seconds delay between each refresh?

Thanks in advance.