I hope I understood correctly, and that I won't make you waste your time. I am a beginner as a vba programmer, but I came across similar problems before.
On that workbook you should have a "Tickers" sheet, to request quotes which, once requested via the button "request market data", keep on...