Run Macro for 2 minutes, stop, refresh queries for 10 seconds and then Loop back to Macro

[jland]

I have an Excel file with 3 tabs that are all pulling info through queries which rotate every 40 seconds. The VBA I have for it works great.
After rotating through the tabs I need the queries to refresh via VBA.
However, since a macro is being ran, the queries wont refresh until I manually stop the macro.
I need help with a macro to:
Run my "TabRotation" for 2 minutes, stop and allow the queries to "RefreshAll" for 5-10 seconds and then loop back and begin the rotation again.

Any help would be greatly appreciated!