I'd take the DoEvents out of the loops.

I'd add one (or two) after you go to your website.
Id add one after you switch sheets or do something that is "outside" of Excel.

I was hoping to not have to read your code but simply have you try...