Retrive and wait macro

Hi Friends.


Can you help me out in creating Macro, i am working in Bloom blerg, i need a macro to retrieve data from the other macro which we already have a addin in the excel, i want a macro to retrive data for 1000 rows (changable) wait for 10 or 15 second (changable), then go to other 1000 rows and do the same..

HI guyz is it possible can this be done?

Attaching file for reference.