Do you want to make your macro pause the screen so that you do not see what is happening till it’s done? This will prevent seeing all the jumping between sheets & scrolling.

Application.ScreenUpdating = False