I am trying to update live web information from Bloomberg. I have four
sheets with a tabed names of "active data", "tickers", "Stored data" and
"Control". "Active data" is where Bloomberg updates the information for
tickers that I have listed on the page. What I would like to do is :

copy values of active_ticker from "Control" sheet, the quarter from "active
data" sheet, and sales from "active data" sheet.
paste values in proper cells that I have defined in the "control" sheet to
the "stored data" sheet
then change active_ticker to the next ticker on the ticker list located in
the "tickers" tab, continue until all have had the information

rereading this it's no wonder I am confused on it all.