Insted of writing code  like a expert, you can do it in very simple way.
Step1: After fetch the data into excel  sheet using web  query.
Step2: Click right mouse button, and select Data Range Properties | Referesh
Control
Step3: and Set Referesh Every 1 min