Stop and restart macro(s) programatically

Good day all,
I've got a series of macros in place which, essentially, download several CSV files into a temp directory, then opens each and copies the data into a single workbook (one sheet).

What happens is that the some number of the sheets don't actually open until the macro stops. I've tried using the wait (Application.Wait Now + TimeValue("00:00:10")) and sleep functions, but it's not quite doing what I want.

What I'd LIKE to do is have the macro actually STOP processing for 10 seconds, then proceed (or start a new macro).

I've also tried putting the wait behind a button in a userform, which is non modal... the csv files open until the user clicks the button.

Help?

Thanks!